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
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