Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rajnidas
Yak Posting Veteran
97 Posts |
Posted - 2014-04-10 : 06:24:25
|
hi every one, i am facing some problem with some query which has given below.i want to get latest updated date on each transid and only for status =approved .-------------------out put would be------------id transid date status3 101 3/1/2014 approved 6 103 1/2/2014 approved table-----------id transid date status1 101 1/1/2014 approved 2 101 2/1/2014 close 3 101 3/1/2014 approved 4 102 1/2/2014 approved 5 102 2/2/2014 close 6 103 1/2/2014 approved i need help Thanks Rajnidas |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|