See a question online, for a table, only two fields (name, grade), how to use SQL implementation
A netizen's answer is such an answer. After reading it, I don't know that there are many skills in SQL.
Declare @Course Table (Name Varchar (100), Grade Int) Insert Into @Course Select 'A', 99 Union All Select 'B', 66 Union All Select 'C', 88 --1Select * from @ Course - 2Select (Select 1 Count (Name) from @Course WHERE grades> T. Score) AS number Grade) AS number, name, grade from @course t) TMP
This will enable SQL ranking on a table.
