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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-09-04 : 12:46:14
|
| DELETE from table1 Where Date =(select max(Date) from table)Please help meThanks,ServerTeam |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 12:50:01
|
| its correct. did you try running it? |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-09-04 : 13:16:13
|
| yes i tried this and i got expected output.I am looking for better queryAs i am not sure if this effects on any performance issueThanks,ServerTeam |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 13:18:43
|
quote:
Originally posted by ServerTeam
yes i tried this and i got expected output.I am looking for better queryAs i am not sure if this effects on any performance issueThanks,ServerTeam
how much time does it take? |
|
|
|
|
|
|
Is this query correct