Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

What is the logical order of execution in a SQL query?

A FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY
B SELECT, FROM, WHERE, GROUP BY
C WHERE, FROM, SELECT, ORDER BY
D FROM, SELECT, WHERE, GROUP BY

Answer

FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY

Because SELECT runs after HAVING, a column alias generally cannot be used in HAVING, which surprises people.

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer