Question

write a SQL query to order the students table. ​

Answer 1

Can you say the full form of SQL???

Answer 2

Answer:

#Assuming that the name of the table here was Student and had a roll number column/filed in there

For ascending:

SELECT * from Students order by Roll asc;

For descending:

SELECT * from Students order by Roll desc;

Explanation:

Using just order by Roll in the end will arrange them in ascending order using roll column