What is the difference between GROUP BY and ORDER BY in
Sql?
Answer Posted / jagadeesh
Groupby: It is a way to sub-total your results,or perform
some other 'aggregate' functions on them.
Orderby: It is a simply a way to sort your results. It
doesn't affect what shows up in your result set,only what
order it is displayed.
| Is This Answer Correct ? | 228 Yes | 35 No |
Post New Answer View All Answers
How can you increase the performance of mysql select query?
What is the latest version of mysql?
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
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
What is mysql data directory?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How can I see all mysql databases?
What are the differences between binary and varbinary?
What is the password of mysql?
Explain what is mysql?
Is primary key auto increment?
What does mysql flush privileges do?
How do I change a procedure in mysql?
What is data in mysql?
What is schema in mysql?