NEW INTERVIEW QUESTIONS.COM ORACLE INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

What is the difference between groupby and orderby?

Answer

Group by is used to group set of values based on one or more values. Order by is to sort values either in ascending or descending order Group by clause is used to group the similar rows in output and order by clause is used to diplay values in ascending or in descending order Answered By: ramesh waje    Date: 5/31/2007 Group by fetches rows based on a function or values.Order by close fetches it based on ascending or descending order of the query we provide Answered By: Govinda Krishna    Date: 6/8/2007 Group by is used to group set of values based on one or more values. Order by is to sort values either in ascending or descending order Answered By: santosh tukaram chankane    Date: 7/6/2007 Group by is used to group set of values based on one or more values. Order by is to sort values either in ascending or descending order Answered By: ruchi shrivastava    Date: 7/11/2007 group by is always written before order by clause...... Answered By: Monalisa Tripathy    Date: 7/20/2007 Group by is give the answer for grouping the table contents,but the order by is give answer of table contents in ascending or descending order Answered By: Rajivgandhi    Date: 7/28/2007 Group by is a clause in select statement which logically segregade a set of records based on the condition imposed on the column. But Order by clause is used to arrange the record in a particular order either in ascending or descending order Answered By: Samrat Biswal    Date: 8/21/2007 Group by is used to group set of values based on . Order by is to sort values either in ascending or descending order Answered By: gowrishankar    Date: 8/28/2007 group bu clause is used,when we have the same value in the columm becoz they group together and order by clause used sequencing or sort the value either in ascending or descending Answered By: nisha dembla    Date: 10/30/2007 why we can't able to create a view that contains order by clause? but it is used in top-N-analysis Answered By: Rajambal    Date: 12/6/2007 Group By clause is always used when U use Aggregate function, While using order by clause is optional. Answered By: Vinod Tejnani    Date: 1/22/2008 Group by is used to group the similar data. Whereas, order by is used to sort the data in ascending or decending order. Answered By: Arup Chakraborty    Date: 2/13/2008 Group by is used to group set of records based on one or more field values. Order by is to sort records either in ascending or descending order based on field value. Answered By: jabbar    Date: 2/18/2008 group by is used to group the values for particular field...order by is used to sort the valuesin ascending or descending order. Answered By: pradeep.r    Date: 3/19/2008 group by will give the listing of various records belongs to same group where as order by gives listing in ascending or decending order in which they appeare. Answered By: mihir Shah    Date: 3/31/2008 GROUP BY associates all records together based on a column and ORDER BY sorts the records alphabetically based on column. Answered By: Tashi Daw    Date: 5/28/2008 group by clause groups the rows in a particular table but order by clause shows the result in Ascending and descending order which are grouped Answered By: amit    Date: 5/28/2008 group bu clause is used,when we have the same value in the columm becoz they group together and order by clause used sequencing or sort the value either in ascending or descending Answered By: jeyaram    Date: 6/7/2008 Group by will give the listing of various records belongs to same group where as order by gives listing in ascending or descending order in which they appear. Answered By: sampath    Date: 7/1/2008 Groupby clause need to group all values in particular domain to make calculation. Orderby clause need to sort the content in ascending / descending order. Answered By: kokila    Date: 9/21/2008 © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	Oracle Interview Questions
Rating	(3.8) By 11 users
Added	7/27/2006
Views	153948
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: