ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Subqueries
Subject:   Subqueries question - multiple conditions
Date:   2007-07-05 16:19:21
From:   Poon
Response to: Subqueries question - multiple conditions

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