摘要： select top 8 * from tablett order by state desc select top 8 with ties * from tablett order by state desc 区别就是用了with ties 最后一行的参数值（在这句里是state相同 ） 如果相同 阅读全文