I have a view listing tickets and reports for those tickets. I want to query LAST REPORT's OPERATOR
SELECT OPERATOR AS EXPR2, NUMBERPRGN, IS_BITIS AS EXPR1
FROM SCADMIN.V_ESKALASYON_2
WHERE (NUMBERPRGN = 'IM1289657')
ORDER BY NUMBERPRGN, IS_BITIS DESC
That query brings the resultset
| IM1289657 | OGUZY | 04.12.2006 14:01:09 |
| IM1289657 | MUJDEO | 01.12.2006 10:42:30 |
| IM1289657 | MUJDEO | 28.11.2006 10:58:22 |
| IM1289657 | ILKERD | 20.11.2006 14:36:12 |
| IM1289657 | ILKERD | 13.11.2006 16:02:27 |
| IM1289657 | ILKERD | 07.11.2006 14:02:21 |
| IM1289657 | ILKERD | 31.10.2006 15:47:56 |
| IM1289657 | SINANK | 19.10.2006 13:00:00 |
| IM1289657 | OGUZY | 18.10.2006 17:25:56 |
Can you help to recover the query sentence above to return only the red marked record (LAST REPORT info written)
Thanks :)
Get The Last Record by Grouping (SSIS with ORA)
Pramod_SN
Mystagogue
I don't know Oracle very well... I hope that this works...
SELECT NUMBERPRGN, OPERATOR, IS_BITIS
FROM SCADMIN.V_ESKALASYON_2 AS Main INNER JOIN
(SELECT NUMBERPRGN, MAX(IS_BITIS) AS Date
FROM SCADMIN.V_ESKALASYON_2
GROUP BY NUMBERPRGN) AS Sub ON Main.NUMBERPRGN = Sub.NUMBERPRGN AND Main.IS_BITIS = Sub.Date
ORDER BY NUMBERPRGN
Drudkh
Hoops, I have forgotten to say that I use that sentence to query from Oracle (SSIS). And there are lots of ticket numbers. I want to query only the red bold ones from Oracle (the criteria of red bold records is that they are last report for the ticket)
Could you help me
em325409