+1 vote
25 views
If need to return 1 if some values is available in table..How can do the same in query.

Like if value is greater than 0 in table then return 1
Category
asked Mar 25, 2016 | 25 views

+1 vote
SELECT        Col_Name, CASE WHEN tabNum > 0 THEN '1' END AS TableNum
FROM            tbl_Name