What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-26 20:48:03
sql limit to 5 results
-- 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-09-22 23:34:05
text search in mysql
mysql> SELECT * FROM tutorial WHERE MATCH(title,description) AGAINST ('left right' IN NATURAL LANGUAGE MODE); +----+---------------------+------------------------------------------------------------------------------------------------------------------... Add solution -
C# 2021-09-19 08:42:02
c# how to fill a datatable
public DataTable GetData() { SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["BarManConnectionString"].ConnectionString); conn.Open(); string query = "SELECT * FROM [EventOne]&q... Add solution -
SQL 2021-09-18 19:19:02
sql server 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 2021-09-17 22:04:01
sql to date
-- 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