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 |
|
daviddeldave
Starting Member
28 Posts |
 Posted - 2001-12-04 : 04:15:31
|
Is there an equilivent to the Access First and Last functions within SQL Server 7 or 2000? David Mercer |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2001-12-04 : 05:04:51
|
| I don't think there's an equivalent of FIRST and LAST in SQL....but if what you want is the TOP (aka first) and BOTTOM (aka last) of an ORDERED RESULT SET, then look up Books Online...for TOP, BOTTOM and ORDER BY.SQL data isn't stored in any particular order, so FIRST and LAST won't guarantee that certain specific records will be returned. |
 |
|
|
|
|
|
First and Last Functions