+1 vote
38 views
in Database Management Systems by (user.guest)

1 Answer

+1 vote
by (user.guest)
selected by (user.guest)
 
Best answer

The MYSQL ORDER BY Clause is used to sort the records in ascending or descending order.

Syntax:

SELECT expressions  

FROM tables  

[WHERE conditions]  

ORDER BY expression [ ASC | DESC ];  

Parameters

expressions: It specifies the columns that you want to retrieve.

tables: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional. It specifies conditions that must be fulfilled for the records to be selected.

ASC: It is optional. It sorts the result set in ascending order by expression (default, if no modifier is provider).

DESC: It is also optional. It sorts the result set in descending order by expression.

Source: https://www.javatpoint.com/mysql-order-by

Related questions

0 votes
1 answer
+1 vote
1 answer
+1 vote
1 answer
asked in Database Management Systems by (user.guest)
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
0 votes
0 answers
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+2 votes
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
2 answers
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+3 votes
1 answer
Welcome to CPEN Talk
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...