Display last record without using Order by Clause

Posted by Saranya Boopathi under Sql Server category on 6/11/2013 | Points: 40 | Views : 1241

select * from Emp where Empid not in (select top ((select count(*) from Emp)-1)Empid from Adhoc_Emp)

Bookmark It

Latest Code Snipptes