I have table containing data for users, I need to get only last 2 users after first user ex
id-username
1-john
2-fredrek
3-sara
4-sarah
I need to get fredrek, sara - how do I do this in SQL Server ??
I know to do that with MySQL I use LIMIT1,2 but with SQL Server I can't
To avoid 2 x TOP you can use ROW_NUMBER (note: you can't use ROW_NUMBER output directly in the WHERE clause of a single statement )
;WITH cRN AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY id) AS rn,
username
FROM
mytable
)
SELECT username
FROM cRN
WHERE rn BETWEEN 2 AND 3
You can use TOP, restricting in the WEHRE clause, not to take the first register
SELECT TOP 2 *
FROM MyTable
WHERE Id > 1
With SQL Server, you can use the TOP command.
You have to make a dual query:
select * from ( select top 10 * from (
select top 20 * from table_name order by 1 asc
) as tb_name order by 1 desc
) as tb_name_last
order by whathever;
You can use TOP in T-SQL:
SELECT TOP 2 FROM table_name
