Zuber Kazi

Zuber Kazi

  • NA
  • 36
  • 34.2k

Search multiple record by multiple columns

Mar 27 2012 3:23 AM
Hello everyone,
              I create a table customer in sql which contains cust_name,cust_add,cust_mob. Now i entered the values in that table having same cust_name but different cust_add and cust_mob. now I want to search multiple data from my table. I used query-
select * from customer where cust_name in ('RAM','SHYAM')
it returns me all records having cust_name RAM and SHYAM but i want only first records of RAM and SHYAM.
I am confused, how to find that using cust_name and cust_add for multiple records??????

Regards,
Zuber Kazi.

Answers (1)