What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-22 19:25:22
learnxinyminutes sql
-- Comments start with two hyphens. End each command with a semicolon. -- SQL is not case-sensitive about keywords. The sample commands here -- follow the convention of spelling them in upper-case because it makes -- it easier to distinguish them from da... Add solution -
Other 2022-01-22 19:21:34
To ignore duplicate keys during 'copy from' in postgresql
create temp table tmp_table on commit drop as select * from brand with no data; copy tmp_table (name,slug) from '/var/lib/postgresql/data/Brands.csv' DELIMITER ',' csv header; insert into brand select distinct on (slug) * from tmp_table; Add solution -
SQL 2022-01-21 23:42:02
oracle show running job
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS; -- connected scheme SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS; -- granted to connected scheme SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS; -- all jobs (DBA) -- More details (DBA) SELECT DISTINCT r.OWNER, r.JOB_NA... Add solution -
Other 2021-11-16 06:41:15
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SELECT DISTINCT CITY FROM STATION WHERE LOWER(SUBSTR(CITY,1,1)) NOT IN ('a','e','i','o','u') AND LOWER(SUBSTR(CITY,LENGTH(CITY),1)) NOT IN ('a','e','i','o','u'); Add solution