Sql snippets

From UVOO Tech Wiki

Revision as of 22:38, 9 September 2023 by Busk (talk | contribs) (Created page with "``` select (select count(distinct status) from T) = 1 ``` will return 1 or 0 (i.e. true or false) depending on whether all of the rows have the same value in Status or not....")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

select (select count(distinct status) from T)  = 1

will return 1 or 0 (i.e. true or false) depending on whether all of the rows have the same value in Status or not. If you have to deal with NULL values in status:

select exists 
( select status from T where status <> 2 or status is null)
as StatusContainsOtherThanTwoOrNullValue

Retrieved from "https://tech.uvoo.io/index.php?title=Sql_snippets&oldid=4521"