1.SQL三个排序函数ROW_NUMBER()、RANK()、DENSE_RANK() ROW_NUMBER()不并列连续的RANK()分组不连续排序(跳跃排序)DENSE_RANK()并列连续 创建实例表: 实例表代码 DROPtableIFEXISTScon; CreateTableIFNOTEXISTScon(idint,Numint); INSERTINTOconVALUES(1,1); INSERTINTOconVALUES(2,1); INSERTINTOconVALUES(3,1); INSERTINTOconVALUES(4,4); INSERTINTOconVALUES(...