vedicveko/top_ten.sql

Created February 7, 2012 17:21

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

Select an option

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

Download ZIP

Order by Top Ten

Raw

top_ten.sql

	SELECT patient_seq, study_date, COUNT(seq) as count
	FROM images
	GROUP by patient_seq
	ORDER by count DESC LIMIT 10

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