Reordering method of SQL

Time:2020-11-11
-- Id         Name      Course      Score   
--1001 Li Si English 100 
--1007 Wang Wu mathematics 30
--1004 Li Si mathematics 62
--1005 Li Siyu 83 
--1006 Wang Wu Chinese 55 
--1008 three English 64
--1003 Wang Wu English 56 
--1002 Zhang San mathematics 93 
--1000 copies of three languages 81

--First sort according to the name field, then sort by the score field, and finally remove the duplicate RN = 1
select name from (
     select name ,row_number() over ( partition by name order by score) rn from table
)name where rn=1

 

@font-face { font-family: “yourDictFontAwesome”; src: url(“chrome-extension://dmckmhkomggmpalekfadjibdcknieljf/lib/fontawesome-webfont.ttf”) format(“truetype”); font-weight: normal; font-style: normal }
@font-face { font-family: “yourDictFontAwesome”; src: url(“chrome-extension://dmckmhkomggmpalekfadjibdcknieljf/lib/fontawesome-webfont.ttf”) format(“truetype”); font-weight: normal; font-style: normal }
@font-face { font-family: “yourDictFontAwesome”; src: url(“chrome-extension://dmckmhkomggmpalekfadjibdcknieljf/lib/fontawesome-webfont.ttf”) format(“truetype”); font-weight: normal; font-style: normal }