What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-10 23:52:01
oracle select first row order by
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 2021-09-05 03:54:02
find the median in sql
# FOR TABLES WITH EVEN NUMBER OF ROWS # For column1 in table1 with 'n' number of rows. Where 'n' is an even number. # 1. Change all column1 and table1 to your column and table name. # 2. Calculate (n/2)+1, where n=number of rows, and set it as LIMIT for ... Add solution -
SQL 2021-09-03 01:11:02
purge undo tablespace oracle 11g
SELECT a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB - USAGEMB) AS FREEMB FROM (SELECT sum(bytes) / 1024 / 1024 AS SIZEMB, b.tablespace_name FROM dba_data_files a, dba_tablespaces b WHERE a.tablespace_name = b.tablespace_name AND b.conte... Add solution