- A single number is a number that appeared only
once in MyNumbers table.
Write an SQL query to report the largest single
number. If there is no single number, report null.
table : MyNumbers
Solution:
select coalesce((select top 1 num from MyNumbers
group by num
having count(num) =1
order by num desc),null) as num
Output:
SQL Script:
Create table MyNumbers (num int)
insert into MyNumbers (num) values ('8')
insert into MyNumbers (num) values ('8')
insert into MyNumbers (num) values ('3')
insert into MyNumbers (num) values ('3')
insert into MyNumbers (num) values ('1')
insert into MyNumbers (num) values ('4')
insert into MyNumbers (num) values ('5')
insert into MyNumbers (num) values ('6')