INTERVIEW QUESTIONS ORACLE DETAILS

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 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 Source: CoolInterview.com

groupby is always used with having clause
whereas we do not use having clause with orderby. Source: CoolInterview.com

groupby is used when we are using aggregate functions in the query but,orderby is not. Source: CoolInterview.com

Not always need aggregator function to use group by. Its can be used to find the distinct values also.

Select emp_first_name, emp_last_name from emp
group by emp_first_name, emp_last_name

Did anybody experienced a situation where they had to use group by instead of DISTINCE? Source: CoolInterview.com

Group by clause used with group function in query, group by clause used for grouping the data.

Order by clause used only for data ordering (ascending or descending). Source: CoolInterview.com

The Simplest answer is

Order by :just sorts a column data.

Group by : Groups it by similar data. Used for aggregation. Order by could be used inside the Grouped Items Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question