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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-30 : 09:28:14
|
| Hendra writes "I'd like to know is there any way or any statement that can help me to get first or last record from the group by query ?I'm using sql Server 2000Thank's_Hendra_" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-30 : 09:55:54
|
| FirstSelect Top 1 ... from table group by cols Order by keycol ASCLastSelect Top 1 ... from table group by cols Order by keycol DESCMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Get First Record from Group By Query