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 |
alhakimi
Starting Member
23 Posts |
Posted - 2014-01-24 : 15:46:00
|
Hi friends , I need your help, i have table has column called [last modified date] it has time too , i need your assistant to get the [latest modified date] for particular ID , there are many updates to the ID and i just need the latest date. [PAX ID] | [Last Modified Date] 1 2013-01-02 18:23:00 1 2013-01-02 11:42:00 3 2013-01-01 09:00:00 3 2013-01-08 16:05:00 5 2013-01-01 09:09:00RegardsAlhakimi |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-24 : 15:53:53
|
select [pax id], max([last modified date])from yourtablegroup by [pax id]Please do yourself a favor and fix those column names! There should be NO spaces.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
alhakimi
Starting Member
23 Posts |
Posted - 2014-01-24 : 16:08:39
|
Thanks my friend |
|
|
|
|
|