is it necessary to write group by and order by clause together
- 3 Answers
- 9577 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
Answer Posted / madhav
yes,
select deptno,sum(sal) from emp group by deptno;
(it displays ascending order)
when we want to display the descending order,we need order
by clause and group clause.
select deptno,sum(sal) from emp group by deptno order by
deptno desc
(it displays the descending order)
| Is This Answer Correct ? | 9 Yes | 10 No |
Post New Answer View All Answers
What pl/sql package consists of?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is normalization? How many normalization forms are there?
What is parallel hint?
What is nvarchar in sql?
What are variables in pl sql?
What is an inner join sql?
What is the use of desc in sql?
What is data type in sql?
What is the sql case statement?
How do I order by ascending in sql?
How many sql commands are there?
what is foreign key? : Sql dba
How much does sqlite cost?
What is the difference between the conventional and direct path loader? : aql loader
