Sql snippets

See if all values are the same

• https://stackoverflow.com/questions/5449134/check-if-value-in-column-for-all-rows-is-exactly-value

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