Q:

How to fetch records according to largest first

How to fetch records according to largest first?
Example
 SELECT  marks FROM  students 

 marks 

  50
  20
  80
  65
  35

But I want to fetch details according to highest marks like this
Marks
 80
 65
 50
 35
 20

A:

You should just user ORDER BY the column you want and ASC or DESC for ascending or descending ordering
SELECT  marks FROM  students ORDER BY marks DESC

