is it necessary to write group by and order by clause together
- 3 Answers
- 10096 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 is the starting oracle error number?
How many types of keys are there in sql?
Explain unique key in sql.
How do you select unique values in sql?
Is pl sql different from sql?
Can I call a procedure inside a function?
What is a sql schema used for?
How does an execution block start and end in pl sql?
Define select, insert, create, delete, update, drop keywords
How many functions are there in sql?
What is flag in sql?
What has stored procedures in sql?
Can we rollback truncate?
Explain scalar functions in sql?
Can you selectively load only those records that you need? : aql loader
