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 |…
