How to retreive last 3 rows from a table which is not sorted in any order
upto my knowledge this is one way
select empno from emp where empno in (select top 3 empno from emp order by desc empno)
here we are sorting the rows and retreving the last 3 records is there any way to retrieve last 3 records with out sorting the table.
Any help is appreciated
Thanks vinay