Displaying 1 result from an estimated 1 matches for "4a8b6bd1".
Did you mean:
0ab6bd1
2006 Jan 09
2
Using SQL to get a whole record when using aggregate functions
I have a table with some data structured something like this:
book
----
title (varchar)
pages (int)
completed_on (date)
While I can find the shortest book completed in each year with
something like this:
select min( pages ), year from book group by year
I would also like to get the title of the shortest book in each year.
Is there any way to do this by modifying the previous query to pull