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

How does rowid help in running a query faster?

0 Answers  

what are date and time intervals? : Sql dba

0 Answers  

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

Explain what is a database?

0 Answers  

What is group function in sql?

0 Answers  

What is left join in postgresql?

0 Answers  

Explain the types of joins in sql?

0 Answers  

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

How many aggregate functions are available there in sql?

0 Answers  

Is sql open source?

0 Answers  

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

What is faster join or subquery?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories