if want to view the list of students in ascending order of marks the whinch statements is used
Answers
Answered by
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