我想将列A的不同值与条件中提到的值进行比较，如果所有值与条件匹配，则将true打印为TRUE

Question

if ((select distinct Column_A from TableA) == ('ab','bc','dc','ec'))
    print 'True'
else
    print 'False'

我该如何在sql？

Answer 1

类似的东西：

select convert(bit,
       case 
       when (select count(distinct column_A) from TableA
             where column_A in ('ab','bc','dc','ec')
            ) = 4
       then 1
       else 0
       end
       ) tf

在线演示