Define two quantities, 12,78 assignment respectively, and judge whether the two number is equal to the output, formula is what? To solve the

CodePudding user response:

Select the case when the count (case when col=12 then 1 end)=count (case when col=78 then 1 end) then one else 0 end

CodePudding user response:

It is mysql or SQL Server, to what's going on!!

CodePudding user response:

reference 1st floor to hit dead Newton's apple's reply:

select case when the count (case when col=12 then 1 end)=count (case when col=78 then 1 end) then one else 0 end

There is no such complex great god

CodePudding user response:

refer to the second floor YXTS122 response:

is mysql or SQL Server, to what's going on!!

This I don't know just into the line