select all rows except top row
rows, sql, sql-server
Solution
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
Problem
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