Display last record without using Order by Clause

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 707
Display last record without using Order by Clause

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

Comments or Responses

Login to post response