试题详情
- 多项选择题Which two statements are true about WHERE and HAVING clauses? （）
A、A WHERE clause can be used to restrict both rows and groups.
B、A WHERE clause can be used to restrict rows only.
C、A HAVING clause can be used to restrict both rows and groups.
D、A HAVING clause can be used to restrict groups only.
E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
F、A HAVING clause CANNOT be used in subqueries.
关注下方微信公众号，在线模考后查看
热门试题
- Evaluate the SQL st
- Examine the structu
- The CUSTOMERS table
- Which view should a
- You need to calculat
- Which two statements
- Which three are DATE
- The STUDENT_GRADES
- Which four are attri
- You need to give the
- Evaluate this SQL s
- Which three SELECT s
- Examine the structu
- Evaluate the SQL sta
- Which four are valid
- Evaluate this SQL s
- Examinethestructureo
- A subquery can be us
- The EMPLOYEE tables
- Examine the structu