Hi Gurus,
My Oracle Version
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
5 rows selected.
SQL> WITH T AS
2 (
3 SELECT 1 ID,'Personal' NAME,2 TYPE,TO_DATE('03/01/2010','MM/DD/YYYY') DT FROM DUAL UNION ALL
4 SELECT 2,'Personal',2,TO_DATE('02/01/2010','MM/DD/YYYY') FROM DUAL UNION ALL
5 SELECT 3,'Personal',2,TO_DATE('05/01/2010','MM/DD/YYYY') FROM DUAL UNION ALL
6 SELECT 4,'Shared',1,TO_DATE('04/01/2010','MM/DD/YYYY') FROM DUAL UNION ALL
7 SELECT 5,'Shared',1,TO_DATE('03/01/2010','MM/DD/YYYY') FROM DUAL
8 )SELECT * FROM T;
ID NAME TYPE DT
---------- -------- ---------- ---------
1 Personal 2 01-MAR-10
2 Personal 2 01-FEB-10
3 Personal 2 01-MAY-10
4 Shared 1 01-APR-10
5 Shared 1 01-MAR-10
SQL>
I need to get the Latest Record from that data group by each Type and to get it as a single record.
My Desired Output:
ID NAME TYPE DT SHARED_ID SHARED_NAME SHARED_DT
---------- -------- ---------- ------------------- -------- ---------- ---------
3 Personal 2 01-MAY-10 4 Shared 1 01-APR-10