I have a table for Documents with following fields
.............. There are more fields
Following is the sample data .
Doc1, Rev1, Loc1
For Given DocumentNo and DocRevision , Location has to be same . In this case Doc1,Rev1 has wrong data .
I am looking for a Sql server query that can bring the wrong data ( In the sample, the query should bring all the three rows of Doc1,Rev1)