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


Postări populare de pe acest blog

5Inch HDMI LCD for RPI 800x480

DevExpress Theme Changer ...

.NET Core Dependency Injection with Func as constructor parameter