Skip to Content
0
Oct 17, 2019 at 12:26 PM

Query Based on Column Value = 0 is not working

184 Views

hi ,

I have a table D***_*****REG in Hana Data base , where value of colum named Tot_score is '0' and its key is '1101058365' .

When i query as " SELECT CALL_REGNO , TOT_SCORE FROM D***_*****REG WHERE CALL_REGNO = '1101058365' I get below

Now with Query "

SELECT CALL_REGNO , TOT_SCORE FROM D***_*****REG WHERE CALL_REGNO = '1101058365' AND TOT_SCORE = 0 "

I get No Output as shown below

Why is the Out Put not coming when Selecting Tot_Score = 0 ?

here 0 is numerical Zero.

Regards

Govardan

Attachments