Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)

A.
The HAVING clause can be used with aggregate functions in subqueries.

B.
The WHERE clause can be used to exclude rows after dividing them into groups.

C.
The WHERE clause can be used to exclude rows before dividing them into groups.

D.
The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.

E.
The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


rca ieftin

rca ieftin

We can be a group of volunteers and starting a fresh scheme within our community. Your website offered us with valuable info to be effective on. You have done a formidable job and our whole community is going to be thankful to your account.
rca ieftin http://goo.gl/6GqA7S

Google

Google

Always a significant fan of linking to bloggers that I enjoy but really don’t get a whole lot of link enjoy from.

Derick Schronce

Derick Schronce

I truly appreciate this article post.Really looking forward to read more. Awesome.