Condition (SQL): Difference between revisions

Revision as of 17:35, 11 May 2020

Revision as of 21:00, 10 July 2020

Line 39:

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

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'':

<syntaxhighlight lang="sql">SELECT *dk FROM tab WHEREGROUP dkBY = 100dk HAVING count(*) > 1</syntaxhighlight>

{{SQL}}