How many ways of getting Last records in SQL-Server?

Posted by vishalneeraj-24503 on 11/27/2013 | Category: Sql Server Interview questions | Views: 2691 | Points: 40

Select from following answers:

select employee_id as last_id from employee_master where employee_id = (select max(employee_id) from employee_master);
select employee_id as last_id from employee_master where employee_id = all (select max(employee_id) from employee_master);
select max(employee_id) as last_id from employee_master;
select top 1 employee_id as last_id from employee_master order by employee_id desc;
All Above