What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-22 14:16:10
sql date format yyyy-mm-dd
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2022-01-22 10:11:37
select query in sql
select [all/distinct] <COL1>, <COL2>, <COL3> from <TABLE_NAME> [join <JOIN_CONDITION>] [where <CONDITION>] [group by <COLUMN_NAME>] [having <SEARCH_CONDITION>] [order by <SORT_SPECIFICATION>] /* Spec... Add solution -
SQL 2021-11-21 18:32:17
convert excel to sql
Using SQLizer... Step 1: Select Excel as your file type Step 2: Choose the Excel file you want to convert to SQL Step 3: Select whether the first row contains data or column names Step 4: Type the name of the Excel worksheet that holds your data Step 5: I... Add solution -
SQL 2021-11-21 07:34:17
sql limit results returned
-- MySql SELECT * FROM emp ORDER BY sal DESC LIMIT 5; -- SQL Server SELECT TOP 5 * FROM emp ORDER BY sal DESC; -- Oracle < 11g SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5; -- Oracle 12c + SELECT * FROM emp ORDER BY sa... Add solution -
SQL 2021-11-19 12:19:11
sql convert string to date yyyymmddhhmmss
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2021-11-19 02:54:08
how to use a trigger to validate input data
DELIMITER $$ CREATE TRIGGER example_before_insert_allow_only_one_active BEFORE INSERT ON example_tbl FOR EACH ROW BEGIN IF NEW.active = 1 AND (SELECT COUNT(id) FROM example_tbl WHERE active=1 AND foreign_key_id=NEW.for... Add solution -
-
SQL 2021-11-16 16:45:21
output data in sql
<?php /* Connect to your database */ $con = mysqli_query("hostname", "username", "pwd", "database"); /* Select Columns from table*/ $sql = "SELECT * FROM `TABLE`"; /* Query your SQL code t... Add solution -
Other 2021-11-14 19:08:11
ruby sqlite
require 'sqlite3'# Browser history db = SQLite3::Database.new "places.sqlite"# List all tables db.execute "SELECT * FROM sqlite_master where type='table'"# List all visited URLs (History)db.execute "SELECT url FROM moz_places... Add solution