Home » SQL & PL/SQL » SQL & PL/SQL » Finding the latest data
Finding the latest data [message #218806] Sat, 10 February 2007 10:27 Go to next message
pakcikkantin
Messages: 4
Registered: February 2007
Junior Member
Greetings
I have records

ID NAME DEPT REGISTERDATE
1 ALI IT 01-FEB-07
2 ABU FINANCE 02-FEB-07
3 SIM IT 03-FEB-07
4 LEE FINANCE 04-FEB-07

I want each department has only latest representative with the latest REGISTERDATE, then the result should be like this

ID NAME DEPT REGISTERDATE
3 SIM IT 03-FEB-07
4 LEE FINANCE 04-FEB-07

I think i should use MAX but don't feel the confidence of the results
Tq

Re: Finding the latest data [message #218807 is a reply to message #218806] Sat, 10 February 2007 10:38 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can utilize this technique.
Previous Topic: Relating to Aggregate function
Next Topic: How to Remove New Line Character in Multilne String
Goto Forum:
  


Current Time: Fri Dec 09 21:20:29 CST 2016

Total time taken to generate the page: 0.10073 seconds