select all rows except top row

sql sql-server rows
D-Dawgg picture D-Dawgg · Feb 22, 2013 · Viewed 22.7k times · Source

how do I return all rows from a table except the first row. Here is my sql statement:

Select Top(@TopWhat) * 
from tbl_SongsPlayed 
where Station = @Station 
order by DateTimePlayed DESC

How do I alter my SQL statement to return all rows except the first row.

Many thanks

Answer

chrisb picture chrisb · Feb 22, 2013

SQL 2012 also has the rather handy OFFSET clause:

Select Top(@TopWhat) *
from tbl_SongsPlayed 
where Station = @Station 
order by DateTimePlayed DESC
OFFSET 1 ROWS

Related questions

Get previous and next row from rows selected with (WHERE) conditions

For example I have this statement: my name is Joseph and my father's name is Brian This statement is splitted by word, like this table: ------------------------------ | ID | word | ------------------------------ | 1 | my | | 2 | name | | 3 | is | | 4 | Joseph | | 5 | and | | 6 | my | | 7 | father's | | 8 | name | | 9 | is | | 10 | Brian | ------------------------------ …

Read More
Combine multiple rows into multiple columns dynamically in SQL Server

I have a large database table on which I need to perform the action below dynamically using Microsoft SQL Server. From a result like this: badge | name | Job | KDA | Match - - - - - - - - - - …

Read More
Insert into a row at specific position into SQL server table with PK

I want to insert a row into a SQL server table at a specific position. For example my table has 100 rows and I want to insert a new row at position 9. But the ID column which is PK for the …

Read More