SELECT * FROM ( SELECT *,ROW_NUMBER() OVER(ORDER BY ID) AS 'RowRank' FROM TABLE1 ) AS TABLE1 WHERE RowRank>1
select * from table1 where id!=(select top 1 id from table1)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)