Condition (SQL): Difference between revisions

Revision as of 14:05, 22 January 2007

Revision as of 14:10, 22 January 2007

Line 6:

SELECT * FROM tab WHERE ''pk = 100''

To '''<tt>SELECT</tt>''' the duplicate rows of data from a table ''tab'' with duplicate key column ''dk'' set to 100 &mdash; use the condition ''dk = 100'' and the condition ''having count(*) > 1'':

SELECT * FROM tab WHERE ''dk = 100'' having count(*) > 1

[[Category:SQL]]