Getting the first & Second highest number record from a table

Let us say that we want the Second record afther the first we will have something like this :

SELECT * FROM student ORDER BY Student.Name Asc LIMIT 1,1

or another example Selecting the first record showing the biggest grade in a exam for a student (just the first record)

SELECT * FROM StudentGrades ORDER BY StudentGrades.Grade Desc LIMIT 0,1

Comentarii

Postări populare de pe acest blog

RpiCar

DevExpress Theme Changer ...