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

 Posted by vishalneeraj-24503 on 11/27/2013 | Category: Sql Server Interview questions | Views: 1596 | Points: 40
Select from following answers:
  1. select employee_id as last_id from employee_master where employee_id = (select max(employee_id) from employee_master);
  2. select employee_id as last_id from employee_master where employee_id = all (select max(employee_id) from employee_master);
  3. select max(employee_id) as last_id from employee_master;
  4. select top 1 employee_id as last_id from employee_master order by employee_id desc;
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response