is it necessary to write group by and order by clause together
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 sql and its types?
Explain aggregate functions are available there in sql?
How does a self join work?
What are the types of join in sql?
What is the purpose of using pl/sql?
How can we solve sql error: ora-00904: invalid identifier?
What is a relationship and what are they?
What is set serveroutput on in pl sql?
Is primary key a clustered index?
What is type and rowtype in pl sql?
what are the differences between require and include, include_once and require_once? : Sql dba
What is the file extension for sql database?
What is data type in sql?
How many parts of a pl sql block are optional?
What is linq to sql?