SQL Server: case case

Question

SQL Server: case case

I have a table named boolean

that contains the values "true" and / or "false" as rows in one column.

I am having a problem creating a statement case

to show me if only values are "true" or "false" or "both"

Example 1:

'true'  
'true'

result: 'true'

Example 2:

'false'   
'false'  
'false'

Result: "false"

Example 3:

'true'  
'false'  
'true'

Result: "both"

Edit:

case

the expression should look like this:

case 
   when  "column content are only true values"  then 'true' 
   when  "column content are only false values" then 'false'
   else 'both' 
end

+3

sql sql-server select case

Mienio June 13. '15 at 9:37

source to share

3 answers

SELECT CASE WHEN MIN(Col) <> MAX(Col) THEN 
          'Both'
       ELSE
          MIN(Col)
       END
FROM YourTable

+4

Zohar peled June 13. 15 at 9:56

source to share

select case when count(distinct bool_column) = 2 then 'both'
            when sum(case when bool_column = 'false' then 1 end) > 0 then 'false'
            else 'true'
       end as result
from your_table

+2

juergen d June 13. 15 at 9:52 am

source to share

Mureinik · Accepted Answer · 2015-06-13T09:55:41+0000

You can combine columns in max

and min

in a column and then evaluate the results - if they are the same, there will be only one value in the column. If not, then both should be. Note that since these are string representations, the values are sorted lexicographically:

SELECT CASE WHEN MAX(col) = MIN(col) THEN MAX(col) ELSE 'both' END
FROM   my_table

SQL Server: case case

More articles: