Select the data with highest update no [message #398361] |
Thu, 16 April 2009 02:00  |
PadmajaKumar
Messages: 7 Registered: November 2006 Location: Chennai,India
|
Junior Member |
|
|
My question may be silly, but sorry for my ignorance.
I have the following the data.
empno updateno salary
1 0 300
2 0 400
3 0 500
1 1 800
2 1 900
1 3 1000
2 2 500
3 4 600
I want the output in this manner.
empno updateno salary
1 3 1000
2 2 500
3 4 600
that is empno, salary with the latest updateno .
Kindly help me.
Thanks in advance.
|
|
|
|