Condition (SQL): Difference between revisions

Revision as of 15:51, 11 April 2013

Revision as of 11:28, 16 September 2015

Line 37:

==Examples==

To '''<tt>SELECT</tt>''' one row of data from a table called ''tab'' with a primary key column (''pk'') set to 100 &mdash; use the condition ''pk = 100'':

<source lang="sql">SELECT * FROM tab WHERE ''pk = 100''</source>

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

To identify whether a table ''tab'' has rows of data with a duplicated key column ''dk'' set to 100 &mdash; use the condition ''dk = 100'' and the condition ''having count(*) > 1'':

<source lang="sql">SELECT * FROM tab WHERE ''dk = 100'' havingHAVING count(*) > 1</source>

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

{{SQL}}