Article:		SQL Subqueries
Subject:		Subqueries question - multiple conditions
Date:		2006-12-10 21:24:50
From:		chandu_sql
Response to: Subqueries question - multiple conditions
I want to get only the records which are doulpicate,how to get them

Showing messages 1 through 3 of 3.

• Subqueries question - multiple conditions
  2007-07-05 16:19:21  Poon [Reply | View]
  
  
  You can do this by using count(column name for which values are duplicate ) in the where cluase of the query and make it>1

• Subqueries question - multiple conditions
  2007-07-05 16:16:26  Poon [Reply | View]
  
  
  You can get the desired result if you take count(the column for which u want duplicate records) in the where clause of the query as >1;

• Subqueries question - multiple conditions
  2007-07-05 16:14:19  Poon [Reply | View]
  
  
  You can get the desired result if you take count(the column for which u want duplicate records) in the where clause of the query as >1;