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
—all employee id of the table)


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: Logo

You are commenting using your 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


%d bloggers like this: