Finding duplicate values in a SQL table

SELECT * FROM
    (
    SELECT Id, Name, Age, Comments, Row_Number() OVER(PARTITION BY Name,Age ORDER By Name)As Rank FROM Customers
    )AS B WHERE Rank>1

Comments

Popular posts from this blog

HOW TO Use the NumericUpDown Control

How To Get IP & Locations details of client machine in asp.net

Get control name in Page_Load event after post back by any control