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 |
|
hzx
Starting Member
3 Posts |
 Posted - 2007-08-27 : 16:09:48
|
| I have a table data format likeID field11 42 33 34 35 76 87 118 11I am trying make a statement to retrieve records with ID 1, 4, 5, 6, 8i.e. for the same value in field1 should only retrieve record with biggest ID. Thank you in advance. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-27 : 16:13:06
|
| is this homework? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-27 : 16:17:29
|
Read about GROUP BY and MAX statements in Books Online, your future best friend.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
hzx
Starting Member
3 Posts |
Posted - 2007-08-27 : 16:24:38
|
quote:
Originally posted by eyechart
is this homework?
This my real work, I am trying almost whole day, no luck at all. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-27 : 17:05:25
|
quote:
Originally posted by hzx
quote:
Originally posted by eyechart
is this homework?
This my real work, I am trying almost whole day, no luck at all.
please paste the SQL query you are trying and we can help you correct it. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-27 : 17:13:08
|
You're bad, eyechart, bad 
E 12°55'05.25"N 56°04'39.16" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
SQL statement help