Difference between revisions of "Sql snippets"
Jump to navigation
Jump to search
(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....") |
(No difference)
|
Revision as of 22:38, 9 September 2023
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