Displaying 1 result from an estimated 1 matches for "completed_on".
Did you mean:
completed_
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
that as wel...