opposite query

Hi,
Need some help with a query, this is what it looks like:
SELECT TOP 10 *
FROM [dbo].[R_Reenval]
Now how do i get the bottom/last 10 records? I tried replacing the
"Top" with "Bottom", "Last"; they both dnt work.
Any help would be highly appreciated. ThanxTOP doesn't give you the "first" rows as such concept doesn't exist. Rows ar
e not ordered. But since
TOP is applied after ORDER BY, you can do something like:
SELECT TOP 10 col1, col2
FROM tbl
ORDER BY col
To get "bottom" based on the same column order, you can do:
SELECT TOP 10 col1, col2
FROM tbl
ORDER BY col DESC
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"amatuer" <njoosub@.gmail.com> wrote in message
news:1160549556.997163.269380@.b28g2000cwb.googlegroups.com...
> Hi,
> Need some help with a query, this is what it looks like:
> SELECT TOP 10 *
> FROM [dbo].[R_Reenval]
> Now how do i get the bottom/last 10 records? I tried replacing the
> "Top" with "Bottom", "Last"; they both dnt work.
> Any help would be highly appreciated. Thanx
>|||Do a reverse sort.
SELECT TOP n
{ColumnList}
FROM MyTable
ORDER BY {SortCriteria}
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"amatuer" <njoosub@.gmail.com> wrote in message
news:1160549556.997163.269380@.b28g2000cwb.googlegroups.com...
> Hi,
> Need some help with a query, this is what it looks like:
> SELECT TOP 10 *
> FROM [dbo].[R_Reenval]
> Now how do i get the bottom/last 10 records? I tried replacing the
> "Top" with "Bottom", "Last"; they both dnt work.
> Any help would be highly appreciated. Thanx
>|||Thanx alot
Tibor Karaszi wrote:[vbcol=seagreen]
> TOP doesn't give you the "first" rows as such concept doesn't exist. Rows
are not ordered. But since
> TOP is applied after ORDER BY, you can do something like:
> SELECT TOP 10 col1, col2
> FROM tbl
> ORDER BY col
> To get "bottom" based on the same column order, you can do:
> SELECT TOP 10 col1, col2
> FROM tbl
> ORDER BY col DESC
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "amatuer" <njoosub@.gmail.com> wrote in message
> news:1160549556.997163.269380@.b28g2000cwb.googlegroups.com...