How to check all rows

[trukhin]

Hi there. If some one can tell me how to check that all rows in the column have
same value. For example all team played 10 games, so in the column games all
rows must have value 10. And if all rows have value 10 then another action can
be performed.

Thanks in advance.
Andrey

[paross1]

Something like this would give you a count of rows where the column wasn't 10.
Any result other than zero means that there are rows where the games value is
not 10. You will get a zero if the games column in all of the rows is 10. (You
will also get a zero if there are no rows at all in the table, or ALL games are
NULL, but otherwise this should give you what you are looking for.)

SELECT COUNT(*)
FROM YourTable
WHERE games <> 10
OR games IS NULL
AND
EXISTS(SELECT 1
FROM Your_table
WHERE games = 10)

Phil

[trukhin]

Thank you very much Phil, it is good idea.