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
- 7013 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreeharibabu
create table products (category varchar2(30), type varchar2(20) ,price number ) ;
insert into products values('c1','t1',100);
insert into products values('c1','t2',200);
insert into products values('c1','t3',300);
insert into products values('c1','t4',400);
insert into products values('c1','t5',500);
insert into products values('c2','t1',100);
insert into products values('c2','t2',200);
insert into products values('c2','t3',300);
insert into products values('c2','t4',400);
insert into products values('c2','t5',500);
insert into products values('c3','t1',100);
insert into products values('c3','t2',200);
insert into products values('c3','t3',300);
insert into products values('c3','t4',400);
insert into products values('c3','t5',500);
select * from products ;
SELECT category, type, AVG(price)
FROM products GROUP BY category, type ORDER BY 1 ;
3 *5 => 15 rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define select, insert, create, delete, update, drop keywords
How do I find duplicates in sql?
How to write a query to show the details of a student from students table whose
Is and as keyword in pl sql?
What is synonyms?
How do I quit sql?
What is varchar sql?
Is sql an operating system?
what is primary key? : Sql dba
What is output spooling in sql*plus?
Why procedure is used in sql?
Explain the components of sql?
What is the usage of nvl function?
Which is faster truncate or drop?
Explain how to use transactions efficiently : transact sql
