What is the difference between GROUP BY and ORDER BY in Sql?

What is the difference between GROUP BY and ORDER BY in
Sql?

Question Posted / pranab

12 Answers
79362 Views
Creative, Renault Nissan, Trikon Networks, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between GROUP BY and ORDER BY in Sql?..

Answer / hari

correct

Is This Answer Correct ?

29 Yes

62 No

What is the difference between GROUP BY and ORDER BY in Sql?..

Answer / ranjani

groupby is used to show the table in ascending order
where as orderby is used to show the table in any order or
same order.

Is This Answer Correct ?

9 Yes

66 No

Post New Answer

More MySQL Interview Questions

Explain timestamp?

0 Answers

What are procedures in mysql?

0 Answers

How to insert html code into mysql database using php?

0 Answers

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers

What is triggers and how it can be used in mysql?

0 Answers

How to use like conditions?

0 Answers

What is mysql server?

0 Answers

How many sql dml commands are supported by 'mysql'?

0 Answers

What is the use of indexing table?

2 Answers

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?