如何删除数据库中的冗余数据(翻译) (16) HAVING COUNT(*) > 3))) WHERE SeqNumber > 3); As you can see, using the RANK() function allows you to eliminate duplicates in a single SQL statement and gives you more capabilities by extending the power of your queries. 正如你所见使用Rank()可以消除冗余数据而且能给你很大的可伸展性