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
- 7011 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay
15 rows
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Write the command to remove all players named sachin from the players table.
What are the steps for performance tuning.
Explain what is a column in a table?
What is primary key sql?
what is the difference between sql and t-sql? : Transact sql
What is delimiter sql?
What is meant by temporal data?
What is a null value?
What is sql profiler in oracle?
what is an index? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Is left join and outer join same?
How to select 10 records from a table?
Is join an inner join?
How do you explain an index number?
