I have created a table in Data Extension that contains 4 fields. All fields are Nullable. One field Name is Checked. In that field the values are Yes and No according to the requirement. Now I want Max count of either YES or NO and that need to be saved in another table in a new column.
Can anyone help me in building this query.
Select Check, CASE COUNT(distinct Winner) WHEN Yes THEN 'Yes' ELSE 'No' END as winner FROM Test_Table
I changed my Query this way:
select max(Final) as Winner from ( Select distinct Seafood, max(Seafood) as Final from Tirumala_Testing_New group by Seafood ) A
This is not printing the max value it is just taking the random value how to display max value