WRITE SQL QUERY TO FIND EMPLOYEES THAT HAVE SAME NAME AND EMAIL.

 TABLE : Employees


SOLUTION:-


select name,email,count(*)

from employees

Group by name,email

Having 

count(*)>1


OUTPUT:-










Post a Comment

Previous Post Next Post