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
Can there be more than one function with a similar name in a pl/sql block?
What is sql*loader?
How do I truncate a word?
differentiate between float and double. : Sql dba
What is a nested table in word?
Does oracle roll back the transaction on an error?
What is sqlcommand?
What types of commands can be executed in sql*plus?
How can you fetch first 5 characters of the string?
Which is faster truncate or drop?
What is nosql db?
What are all different types of collation sensitivity?
How much ram can sql express use?
What is indexing in sql and its types?
what is the bond code in materialized view?