|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Yes. The proper order for SQL SELECT clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY. Only the SELECT and FROM clause are mandatory.
Create Date
:
Wednesday, September 12, 2007
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
The clauses of the subselect are processed in the following sequence (DB2):
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
SELECT clause
ORDER BY clause
FETCH FIRST clause
Create Date
:
Wednesday, September 12, 2007
Tags
:
sequence,
select,
SQL,
Statement,
processed,
FROM,
WHERE,
GROUP BY,
HAVING,
ORDER BY,
FETCH FIRST
Click here
to improve the Interview Question, Answer and other fields.