Confusion got cleared
Abhishekh KT, March 29, 2016 - 4:41 pm UTC
Good explanation.. and thanks for the links too...
March 30, 2016 - 1:10 am UTC
Glad we could help
Null and 1 in not exists
A reader, July 19, 2019 - 6:41 am UTC
what if we write this
select * From racer where not exists (
select 1 from EVENT where id = winid
);
instead of
select * From racer where not exists (
select null from EVENT where id = winid
);
July 19, 2019 - 2:09 pm UTC
There's no real difference; I prefer null to show you're not really selecting anything.