Interested to Buy Any Domain ? << Click Here >> for more details...
is it necessary to write group by and order by clause together
- 3 Answers
- 10851 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what are the drivers in mysql? : Sql dba
What is the difference between left and left outer join?
What are stuff and replace function?
How pl/sql source code can be protected?
What can I use instead of union in sql?
Difference between truncate, delete and drop commands?
Is it possible to create the following trigger: before or after update trigger for each row?
What is a join?Explain the different types of joins?
6 Answers Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,
What is the use of count (*) in sql?
What are the usages of sql?
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
What are pl/sql packages?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
