Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / pinku325

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

More SQL PLSQL Interview Questions

what is dbms? : Sql dba

0 Answers  

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

What is function and procedure in pl sql?

0 Answers  

What is #table in sql?

0 Answers  

What is set transaction?

0 Answers  

Is sql pronounced sequel or sql?

0 Answers  

What are tuples in sql?

0 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

what is difference between delete and truncate commands? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories