Women in Technology

Hear us Roar



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
Full Threads Newest First

Showing messages 1 through 3 of 3.

  • Subqueries question - multiple conditions
    2007-07-05 16:14:19  Poon [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:16:26  Poon [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:19:21  Poon [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