Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between GROUP BY and ORDER BY in
Sql?
- 12 Answers
- 78981 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 |
What is the usage of regular expressions in mysql?
What is the limitation of mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
What is mysql root?
How do you login to MySql using Unix shell?
Can you tell a way to know the number of days between the two given dates in php?
How do I restore a mysql database?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
What are the common mysql functions?
What is default schema in mysql?
A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
How many sql dml commands are supported by 'mysql'?
-
Oracle (3259) - 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)
