试题详情
- 多项选择题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 if the query uses a HAVING clause.
F、A HAVING clause CANNOT be used in subqueries.
关注下方微信公众号，在线模考后查看
热门试题
- Which four are attri
- Examine the descrip
- Which iSQL*Plus feat
- You need to change
- Which four are types
- Which constraint can
- Evaluate the SQL st
- Which three are DATE
- When should you crea
- Which SQL statement
- Which SQL statement
- Click the Exhibit bu
- Examine the structu
- Which statement desc
- The EMP table has t
- Examine the structu
- TheEMPLOYEEtableshas
- Which is an iSQL*Plu
- You need to calculat
- TheORDERStablehasthe