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
- 3 Answers
- 6066 Views
- I also Faced
- E-Mail Answers
Answer Posted / hemanth
5 Rows
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is sql sequential or random?
what is “go” in t-sql? : Transact sql
What is trigger explain with example?
What does select count (*) mean in sql?
How do I count duplicates in sql?
What are the types of join in sql?
What are the disadvantages of not performing database normalization?
What are different types of sql commands?
What is sql profiling in oracle?
What is not equal in sql?
Mention what is the use of function "module procedure" in pl/sql?
How do I run a sql query?
how to shutdown mysql server? : Sql dba
Can unique keys be null?
Why do we need databases?
