What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 74550 Views
- Creative, Renault Nissan, Trikon Networks, I also Faced
- E-Mail Answers
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 |
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
How many columns can be used for creating Index?
how can you test for null values in a database? : Mysql dba
Is foreign key indexed mysql?
What is innodb mysql?
How to get data from mysql in php?
What is a scalar function?
How to load data files into tables with 'mysqlimport'?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How do I change a procedure in mysql?
How can you filter the duplicate data while retrieving records from the table?
How do you create a new database in mysql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
