I have an Sql Server database with table Documents
There are many duplicates rows with same Document_No . But I need to get only one row from each document no
From the following sample data , I am looking for a query
Doc1 Proj1 Path1 ......
Doc1 Proj1 Path2
Doc2 Proj1 Path2
Doc3 Proj1 Path3
Query Should return rows with Doc2 and Doc3 and one of the Doc1 row (it does not matter which one)