SELECT category, type, AVG(price)
FROM products GROUP BY category, type ORDER BY 1, 2
If there are three distinct categories in the "products"
table, and each one has five different types, how many rows
are returned by the query above?
1. 1 row
2. 3 rows
3. 5 rows
4. 8 rows
5. 15 rows
Answer Posted / hemanth
5 Rows
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by field in sql?
What is an example of translating a date into julian format?
How do you change a value in sql?
What are the operators used in select statements?
How to assign sql query results to pl sql variables?
how to get a list of columns in an existing table? : Sql dba
what is column? : Sql dba
what is the use of friend function? : Sql dba
What is file based approach?
What is the meaning of disabling a trigger?
What is the advantage of index in sql?
How you improve the performance of sql*loader? : aql loader
Explain what is dbms?
Is pl sql still used?
What is query syntax?