Fetch last 2 records from the table

Hi Deepak,

1) SELECT TOP 2 * FROM (SELECT * FROM table_name WHERE ename ORDER BY ASC) tab
2) SELECT TOP 2 ename,

ROW_NUMBER() OVER (ORDER BY ename) AS num

FROM dbo.table_name ORDER BY num DESC

If you have any issues then reply me back.

hi,

It is quite difficult if your column data type is varchar.

but try,

select * from tableName where ename not in (select top ((select count(*) from tableName) - 2) ename from tableName)

above query is not working properly when your table contain duplicate value.

hope this help.

brunda k14y ago

select Top 2 ename,RowId from ( select ename, ROW_NUMBER() over (order by ename desc) as RowId from ename
) dt