浅谈数据库去重关于sql去重，我简单谈一下自己的简介，如果各位有建议或有不明白的欢迎多多指出。推荐网址：www.4-yecao.com
关于sql去重最常见的有两种方式：DISTINCT和ROW_NUMBER()，当然了ROW_NUMBER()除了去重还有很多其他比较重要的功能，一会我给大家简单说说我自己在实际中用到的。
假如有张UserInfo表，如下图：
现在我们要去掉完全重复的数据：SELECT DISTINCT * FROM dbo.UserInfo结果如下图：
PRgEg172pjVzCt3KL6ToeuGq5HsUGjRdjpTgZj9N0/2Ph1X2pksJBt0oWBvuz3hRXBFxIce+uyPuWkzQLuyfX048fZym7/cPw3C2xgHA+6s1Hmlw3mtmbw4uI+5P8wO4aEjR3Td0AAn2vZHxKsZT6Jk9shFin+wCopgGxrTvpRuyH6Nyxf7p+ZWnj+N09+3+bTgvI3DdvONpBudtRAj5TIKitY07lRwi85OWL9bGqsSF/e+nF54+jtPXu++nt0GsQSpFAPBuS/BolriwP/5+5unjOH75+u10GsQaJFRc8lKaR7PEhf3h+MTTz+P4+cvd6+lNrMHqigwezRLKXpwiN/t/td1eu7A/M7ZhGIQbrK7I4NEwDBf2e94GAOQ/tW1qM/gK6/cfPv5D2E1PeHppRU773OwBgJA9ACj7Zthr3suxfxN5Tzg9KPt09gx5bz4Dt9ibJwGEmxA2vbEP5X3afIBzspCTZD/CxrIfcybl2C/CHgqUOC7sQwjT2ONZYrKnmvZDipZEaJvKPg17t9YRClQ5zp0n75E5vxx7hDcJeyovrtjHF0/md+R6T5j3obk3bRJOZtPAnM/MnifvvSPe8a1nhua99Lz3zvmc93qNsF8roCPSDe/zScKn7NPZhxDOjSTvq7B3Lxm013uSmxWbvVkZGFlSmNyZn+uZyKnwd/Vsh7PWke15vpuC3g8gTQKb8uwZax11HU+UfeCsd9N1PFH2udlr3suxz1qrqXkvyj5rrabmvSj7FWodQQs1q7Z39oWWa0NruG1lSd28LG1f2ctSVPZSIqXsm2dPeEuo7EWzdx/Neh/mJzzQVfb07JMXqfBIWchJsj/ShfiTKd4j8uO32S+Hy8YeX3ShYk817Ue6kCyHn1vE7Iu+xdGt1cSPjIQ9Mue3y57Kiyv2obc4QoHKLdwxqjnfsrPpcp7DZufMNAly1diXLtljy3vviHd865mRwEbu9Z65VpOHvXfOJ49d5JELZh94U2Chej3cpXL3elTh2zTTtMS+KPgQ+x3X/3hF2XsnG8LrPcnNis0+5kWXhLWamYeezJ4Kf1fPdphrNXkiZaVI5F1ezB1fX+x5azXbilTn7Jnr9dqKlLJX9p2yZ67VbCtSnbNnrtVsK1Kds8fr+rT1197Zl1ir3bSGKzlL6uZlafvKXpaispcSKWXfNnuSJRBl3wb7yOe1+kxXEPuEBI0xCIHFe3d1J2a9J6TonjSrp1GmfXr2iwYz+zTHcIM4UUL24KwbuSM5HiVbW2EvoVYzlJrJkQoFy5rzb529