is it necessary to write group by and order by clause together

Question Posted / pinku325

3 Answers
10094 Views
HCL, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it necessary to write group by and order by clause together..

Answer / guest

No it is not necessary.

Is This Answer Correct ?

36 Yes

2 No

is it necessary to write group by and order by clause together..

Answer / suman

No Required.

Group by is grouping the records

but Order by mention the data should be desc or asc order.

Is This Answer Correct ?

0 Yes

0 No

is it necessary to write group by and order by clause together..

Answer / 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