asjustas/gist:4117951

Created November 20, 2012 13:32

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

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

Download ZIP

Sort before group by

Raw

gistfile1.sql

	SELECT * FROM

	(
	select * from `my_table` order by timestamp desc
	) as my_table_tmp

	group by catid

	order by nid desc

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