摘要：
name class scoreselect name,class,score,rank() over (partition by class order by score desc) rank1,row_number over(partition by class order by score... 阅读全文
摘要：
charindex（expression1，expression2[,start_location]）expression1是要到expression2字符串中寻找的字符，如果start_location为零，负数或者没有，则表示从起始位置开始寻找，函数返回的整数为expression1在expre... 阅读全文