How to get max of composite data in SQL?
- by Siddharth Sinha
SELECT "Name""Month","Year","Value"
from Table
WHERE
"Name" LIKE '%JERRY%'
AND "Year" =
(SELECT MAX("Year") FROM Table where "Name" LIKE '%JERRY%')
AND "Month"=
(SELECT MAX("Month") FROM Table
where
"Name" LIKE '%JERRY%'
AND "Year"= (SELECT MAX("Year") FROM Table where "Name" LIKE '%JERRY%'))
Table --
Name | Year | Month | Value
-----------------------------
JERRY 2012 9 100
JERRY 2012 9 120
JERRY 2012 9 130
JERRY 2012 8 20
JERRY 2011 12 50
So i want the first three rows as output. As for the latest month for the latest year i need all the values.
Can someone suggest a better cleaner query?
