Hi,
I just want to retrieve name of the employees who have two or more than two email_id in employee table. pls help me out..

select * from employees
group by employee_id
having count(employee_id) >= 2

your question is not clear

How are emails stored in table?
do you have separate columns to save each email ids
or they are saved in 1 columns

if email ids are saved in separate columns
then try


if email ids are saved in single column
then try