摘要:
-- 1.连续3次成绩上升with t as(select id, StudentName, Score, row_number() over(partition by StudentName order by id desc) 'rn' from #t)select distinct a.id,a 阅读全文
摘要:
在SQL中我们经常用到null值, 那么什么是NULL?如下是MSDN给出的一段简短描述(见“Null Values”):•A value of NULL indicates that the value is unknown. A value of NULL is different from a 阅读全文