sql server

Question

Hi I have two table EmployeePhone how get only empid and phone number with distinct phone number below table Employee empid name 1 siva 2 jose 3 ramya ------ Phone empid phone 1 9960076000 1 8860076000 2 7760076000 3 9160076000 2 9060076000 3 9060076000

Santhosh Kumar Jayaraman · Answer

What do you mean by distinct phone number? In your phone table you have only id and phone number and you need empid and phonenumber as output. Then you no need to use employee table.. This phone table should already have distinct records it looks like. For each empno same phone number wont be inserted twice. Even in case if you have same phone number twice for an employee then use group by/distinct Select empidphone from phone group by empid phone or select distinct empid phone from phone

Akkiraju Ivaturi · Answer

I agree with Santosh... Revisit your table structure...

Vilas Gite · Answer

hi Manuel please use Distinct with join query SELECT DISTINCT a.empidb.phone FROM Employee a Phone b WHERE a.empid = b.empid ORDER BY a.empid Thanking you!