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-05-23 : 00:24:29
|
Robert writes "In Access you can select the first instance of a record, is there any way to do the same in SQL Server 6.5. Example of problem is :
We select Num1,Num2,Num3,Num4,Date
Num1 - Num4 are the same and Date is variable.
Example data:
1,1,1,1,12/10/99
1,1,1,1,12/11/99
1,1,1,1,01/01/01
Result Set wanted :
1,1,1,1,12/10/99
How do we get one distinct record back without doing a first on the date." |
|
|
|
|
|
|
|
Selecting First Instance of a field