Software Testing

select * from Employee (nolock) where Empid in
(
SELECT DISTINCT Empid FROM Employee (nolock) WHERE Empid IN
(‘8807′,’32835′,’49962′,’486734′,’39871′,’17753′,’18726’
—all employee id of the table)
GROUP BY Empid
HAVING COUNT(Empid) >1
)

View original post

Advertisements