|
-
Sep 24th, 2002, 06:29 PM
#1
Thread Starter
Frenzied Member
Is there a "First" command in SQL?
In access, I can add the First command to a select query in order to pull the first occurance of a unique record, but there does not seem to be a First command in SQL Server. Does anyone know the equivalent?
So for example, say I have the following data:
0001 | Dan Bassett | This is a test
0001 | Dan Bassett | This is another test
If I were to do a Select on this, both records would return, but how would I limit it to just the first record?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|