Which of the following statements/ statement are true? (i) In SQL you can create virtual tables. (ii) SQL is only data manipulation language. (iii) WHERE clause applies to output of a GROUP BY command. (iv) HAVING clause applies to column and expressions for individual rows.

Keep practicing — related questions

• Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause ...
• In a select with a group by clause, a where clause, and a having clause, the where conditions are applied b...
• Which of the following statements is/are true about having and group by clause? (a) Group by clause can wor...
• Which of the following is/are the difference(s) between having and where clause? (a) Where is used to filte...
• What is true about WHERE clause ?
• Which of the following SQL clauses is used to place a condition while arranging identical data into a group?
• The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.
• When do we use a HAVING clause?