Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7012 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
What is sql entity?
Can delete statement be rollbacked?
explain the advantages and disadvantages of stored procedure? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
Why truncate is faster than delete?
How to sort the rows in sql.
How can you load multi line records? : aql loader
How many triggers can be applied on a table?
What is cursor in pl sql with examples?
Is it possible to update views?
how to convert dates to character strings? : Sql dba
How do I sort a table in sql?
How do I trace sql profiler?
What does := mean in pl sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
