Order by and Group by

Data Warehousing Community Forum > Databases > Oracle > Order by and Group by

Pages: [1] Go Down

« previous next »

Author

Topic: Order by and Group by (Read 913 times)

Sipra

Founder

Reputation: +59/-0
Offline

Offline

Posts: 323

Am the King...

Order by and Group by

« on: August 29, 2007, 09:28:20 am »

Friends,

Please differentiate between Group by and Order by clauses ?


	Logged

Sipra
Founder

www.dwforum.net

rajeshmavuloori

DW Fresher

Reputation: +0/-0
Offline

Offline

Posts: 6

Re: Group by and Order by

« Reply #1 on: September 17, 2007, 02:13:55 pm »

Hi All,

SYNTAX:--
I THINK EVERY ONE KNOW THIS SYNTAX.

SELECT * FROM <TABLE-NAME>
WHERE
GRUOP BY....
HAVING.....
ORDER BY....

GROUP BY is group entire columns and given one value result.
eg:-- Aggrate Functions.

ORDER BY means display the columns either ascending (or) descending order.
Default is asc.


	Logged

unknown

DW Apprentice

Reputation: +8/-0
Offline

Offline

Posts: 44

Order by and Group by

« Reply #2 on: August 29, 2007, 09:28:20 am »

Difference between Order by and Group by?

Sometimes both will mean the same… Can anyone differentiate between these with a best example?

My doubt is when both are same then what is the necessity of using group by ? Undecided

Admin - Merged Topic as it was a Duplicate...!


« Last Edit: January 22, 2008, 10:54:19 am by Sipra »	Logged

Thanks
Unknown

Pages: [1] Go Up

« previous next »

Jump to: