Computer Science, asked by lk3598777, 1 month ago

if want to view the list of students in ascending order of marks the whinch statements is used​

Answers

Answered by nihithach9
0

Answer:

We can specify ASC to sort the result in ascending order.

SQL Order By clause syntax

The results we get from a table we may have to display in an order. The result may be from highest to lowest or lowest to highest in a numeric field or from A to Z or Z to A in a text or varchar field. We may require a combination of this also.

We can apply this to our numeric field mark to display the list in order of lowest mark to highest mark  by using the ASC command ( ascending command ) . Please note that by default all order by commands are in ascending order only.  Here is the command to display the records in decending order ( from highest to lowest ) based on the mark field.

Explanation:

Similar questions