What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-28 17:20:05
oracle first row
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) WHERE ROWNUM = 1; -- Oracle 12c: SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) FETCH FIRST 1 ROW ONLY; SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [... Add solution -
SQL 2022-02-26 19:00:06
maximum element in sql
Who is the person getting 1st max salary SELECT first-name FROM employees WHERE salary = (SELECT MAX(salary) FROM employees); 2nd max salary= SELECT first-name , salary FROM employees WHERE salary = (SELECT MAX(salary) FROM employees WHERE salary NOT IN ... Add solution -
SQL 2022-02-09 06:45:17
mysql max date
-- Max date for each model: SELECT model, max(date) FROM models GROUP BY model; -- All models matching the max date of the entire table: SELECT model, date FROM models WHERE date IN (SELECT max(date) FROM models); -- Same with model details: SELECT d.mode... Add solution -
SQL 2022-02-03 00:25:24
oracle select first result
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) WHERE ROWNUM = 1; -- Oracle 12c: SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) FETCH FIRST 1 ROW ONLY; SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [... Add solution -
SQL 2022-01-24 02:46:21
how to check nls format in oracle
SELECT * FROM (SELECT 'SESSION' SCOPE, nsp.* FROM NLS_SESSION_PARAMETERS nsp UNION ALL SELECT 'DATABASE' SCOPE, ndp.* FROM NLS_DATABASE_PARAMETERS ndp UNION ALL SELECT 'INSTANCE' SCOPE, nip.* FROM NLS_INSTANCE_PARAMETERS nip) a PIV... Add solution