Field is A field B
1??
2??


Use oracle statement found that data
Field is A field B
1 0
2 0

CodePudding user response:

Select A, case when trunc (B)=B, then B
The else 0 end as B
From the table

CodePudding user response:

Here said the integer is how to define? And negative integer is an integer?

CodePudding user response:

Field type B, also had better to say,