DB2 - Write down the syntax order & execution order of SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY& FETCH FIRST clauses

 Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 892 | Points: 40
Answer:

SYNTAX ORDER
============
SELECT FROM WHERE GROUP BY
HAVING
ORDER BY FETCH FIRST


EXECUTION ORDER
===============
FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY
FETCH FIRST


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response