Search multiple record by multiple columns

Hi,

This will work...

CREATE TABLE CustomersTable

(

CustomerID INT IDENTITY(1,1) PRIMARY KEY

,Cust_Name VARCHAR(100)

,Cust_Add VARCHAR(100)

,Cust_Mob VARCHAR(10)

)

INSERT INTO CustomersTable(Cust_Name,Cust_Add,Cust_Mob)

VALUES('RAM','Bangalore','9898989898')

INSERT INTO CustomersTable(Cust_Name,Cust_Add,Cust_Mob)

VALUES('SHYAM','Bangalore','9898989898')

INSERT INTO CustomersTable(Cust_Name,Cust_Add,Cust_Mob)

VALUES('RAM','Chennai','9999912345')

INSERT INTO CustomersTable(Cust_Name,Cust_Add,Cust_Mob)

VALUES('SHYAM','New Delhi','9898989898')

--SELECT * FROM CustomersTable

SELECT DISTINCT CustomerID,cust_name , Cust_Add,Cust_Mob

FROM customersTable t1 WHERE CustomerID =

(SELECT MIN(CustomerID) FROM customersTable t2 WHERE t2.cust_name = t1.cust_name)

If it solved you problem then mark it as "Accepted Answer"

1 Reply

Know the answer? Post it — somebody with the same question will find it here.