Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  
 Our Services  
NEW INTERVIEW QUESTIONS.COM ORACLE INTERVIEW QUESTIONS DETAILS


NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.

A D V E R T I S E M E N T




Add to My Questions Add to My Questions | Forward Forward | Print Print


Question Question What is the difference between groupby and orderby?

Answer 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


If you have the better answer, than send it to us. We will display your answer after the approval.
Answer Answer:*
Name Name:*
Email Address Email Address:*
     Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
 


Rate the above answer. Help us to know about the answer.
Category Category Oracle Interview Questions
Rating Rating (3.5) By 60 users
Added Added 7/27/2006
Views Views 153948
Rate it Rate it!
Free Offers 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:





 Sponsors  

Latest 10 Answers
When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
Honesty, helpful and reliable
procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
variable cost is the cost which is not fixed in nature

Newinterviewquestions.com is a part of Vyom Network. Top



Copyright © 2017, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

Page URL: http://www.newinterviewquestions.com/interview/8561/Default.asp?cachecommand=bypass


Download Yahoo Messenger | Web Hosting | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic