What is the ORDER BY statement in MySQL?

0 votes
Hi!!

Can someone tell me what is ORDER BY statement in MySQL?
Nov 23, 2018 in Database by DataKing99
• 8,100 points
19 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

This statement is used to sort the desired results in ascending or descending order. By default, the results would be sorted in ascending order. If you want the records in the result-set in descending order, then use the DESC keyword.

Syntax:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;
answered Nov 23, 2018 by darklord
• 6,140 points

Related Questions In Database

0 votes
1 answer

what is the syntax of OR statement in MySQL?

The OR operator displays those records which ...READ MORE

answered Nov 30, 2018 in Database by darklord
• 6,140 points
38 views
0 votes
1 answer

What is the ALTER command in MySQL?

ALTER The ALTER command is used to add, ...READ MORE

answered Nov 28, 2018 in Database by darklord
• 6,140 points
53 views
0 votes
1 answer

What is the UPDATE command in MySQL?

This statement is used to modify the ...READ MORE

answered Nov 28, 2018 in Database by darklord
• 6,140 points
37 views
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

answered Dec 13, 2018 in Database by darklord
• 6,140 points
52 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,100 points
31 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
954 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
111 views
0 votes
1 answer
0 votes
1 answer

What is GROUP BY statement in MySQL?

This statement is used with the aggregate ...READ MORE

answered Nov 23, 2018 in Database by darklord
• 6,140 points
32 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

answered Nov 27, 2018 in Database by darklord
• 6,140 points
58 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.