理解查询中的问题 [英] problem in understanding query

问题描述

大家好！!!!

请告诉我0.0和0在下面的查询中表示什么.我用谷歌搜索，但找不到答案.

Hi all !!!

please tell me what does 0.0 and 0 signifies in the below query. I googled it but was unable to find the answer.

"Select 0.0 gpf_Contribution, 0.0 Advance_return, 0.0 Total, 0.0 Advance_return_amt, 0.0 progressive, 0 month_num where 1=2"

推荐答案

HI，

该查询将不给出任何结果，因为您的where条件永远不会变为 TRUE .

如果删除 where 条件，您将得到以下结果.

This query will NOT give any result, as your where condition never become TRUE.

If you remove your where condition you will get the following result.

gpf_Contribution Advance_return  Total  Advance_return_amt   progressive  month_num
   0.0               0.0          0.0       0.0                 0.0           0    

希望您一切都好.

问候
塞巴斯蒂安

I hope you are clear.

Regards
Sebastian

这篇关于理解查询中的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！