Software Testing

Retrieval of duplicate values from the table

Posted on: December 23, 2014

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
)

Advertisements

1 Response to "Retrieval of duplicate values from the table"

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


  • None
  • SutoCom: Reblogged this on SutoCom Solutions.
  • Ankur Mishra: Nice explaination. I have been faced this question in my recent interview..
  • Rajeev: Dear Readers ! I am Rajeev having 5 years of experience in Software Testing industry. The purpose of this site is to explore the ideas and suggestions

Categories

%d bloggers like this: