Given a table of records with empid, contact number; write a query to print empids who have multiple phone numbers

Question

1.00/5 (1 vote)

See more:

Given a table of records with empID, contact number; write a query to print empIDs who have multiple phone numbers

What I have tried:

Select empID frm tblEmp having(contactNum) > 1

Assuming tblEmp is our table.
Tried to get the data with above query but its not working...

Posted 29-Jan-18 19:51pm

Updated 29-Jan-18 20:14pm

Comments

[no name] 30-Jan-18 2:15am

Please mention your table schema with some records in your question and use Improve question link to modify your question.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2018-01-29T20:14:00

try

Select empID from  tblEmp group by empId having count(*)  > 1

Posted 29-Jan-18 20:14pm