Skip to content

Instantly share code, notes, and snippets.

@koobitor

koobitor/oracle.md

Last active April 10, 2020 13:57
Show Gist options
  • Save koobitor/0c7c95089375bf8bfa6befec9e20d469 to your computer and use it in GitHub Desktop.
Save koobitor/0c7c95089375bf8bfa6befec9e20d469 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle.md

Limit By Row

SELECT * FROM [TABLE] WHERE ROWNUM <= [NUMBER];

SELECT by DATE

SELECT * FROM [TABLE] WHERE [DATA_DATE] = TO_DATE('2020-04-10','yyyy-mm-dd')

DISTINCT

SELECT DISTINCT DATA_DATE FROM [TABLE]

Order By

ORDER BY DATA_DATE ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment