Loading

Can I help to return true or false for output with this kind of query?

Nabin Agarwala

Hey guys, Can I help to return true or false for output with this kind of query? select (select 1 from a where fk = b.id) as output from b I could change it to select true from, but I would still get null if the inner select does not find a record

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
Hello Nabin,

There's EXISTS which returns a boolean Or use count(*) > 0 on your inner SELECT
+1
Salman Beg5y ago
The best way to return true or false is by using case statement. Follow this link, https://www.itsupportguides.com/knowledge-base/sql-server/sql-return-truefalse-if-query-rows-returned/ https://stackoverflow.com/questions/56768136/need-sql-query-for-returning-true-or-false-based-on-table-unique-column-value/56768444
0