naranjja/last_n_sort.sql

Created February 4, 2020 22:43

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/naranjja/e17947f398c6fd7c48a271ee6b7417b5.js"></script>
Save naranjja/e17947f398c6fd7c48a271ee6b7417b5 to your computer and use it in GitHub Desktop.

Download ZIP

Get last N_ROWS and sort ascending afterwards in Oracle 11.g

Raw

last_n_sort.sql

	select *
	from (
	select *
	from TABLE
	order by SORT_COLUMN desc
	) temp
	where rownum <= N_ROWS
	order by SORT_COLUMN asc;

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