What is the difference between GROUP BY and ORDER BY in
Sql?
Answers were Sorted based on User's Feedback
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 |
Explain timestamp?
What are procedures in mysql?
How to insert html code into mysql database using php?
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
What is triggers and how it can be used in mysql?
How to use like conditions?
What is mysql server?
How many sql dml commands are supported by 'mysql'?
What is the use of indexing table?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
how to display nth highest salary from a table in a mysql query? : Mysql dba
Why do we use group by and order by function in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)