sql server规范

 

排序函数：over [asc]

排序子句：order by

分组子句：partition by

isnull((select top 1 GradeName from....),'普通会员')