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 - 2001-11-13 : 19:25:47
|
| Jafedo writes "I have a table with following rows :Code1 Code2 Date----- ----- ----------A 1 2001-10-06A 2 2001-10-05A 3 2001-10-04B 1 2001-10-03B 2 2001-10-02C 1 2001-10-01I want to appear only first rows (with all columns) each group on 'Code1'How does I write my 'select' command to retrieve rows that i want?"" |
|
|
|
|
|
Select First Row Each Group