I have a table:ID FK Num Color1 A 5 Red2 A 2 Blue3 B 2 BlueI need a query that will give me the result set of:Number Red Number Blue Total5 4 9
Tag: query
PL/SQL: How to query 2nd record only if sorted by date?
The PL/SQL code in order to return the second latest record ?