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

.NET Core Dependency Injection with Func as constructor parameter

Building Cross-Platform Desktop Apps with Electron.NET