What is the binding order or logical processing order for the following query?

SELECT DISTINCT(sDepartment) FROM tblEmployee
WHERE EMPID BETWEEN 1000 AND 2000

Please select the correct order of the above query execution.

 Posted by Nagasundar_Tn on 12/4/2012 | Category: Sql Server Interview questions | Views: 9735 | Points: 40
Select from following answers:
  1. SELECT , DISTINCT, FROM, WHERE
  2. FROM, WHERE, SELECT, DISTINCT
  3. DISTINCT, SELECT, WHERE, FROM
  4. WHERE, DISTINCT, FROM, SELECT
  5. All Above

Show Correct Answer


Asked In: Ramco Systems | Alert Moderator 

Comments or Responses

Login to post response