Select 1 from dual where null & gt;=null is not the result is I can understand, but

Select * from emp where comm & gt;=comm can comm is empty inside, I was a little doubt life

CodePudding user response:

 select decode (null, comm, 1, 2) from emp where comm & gt;=comm 

Look at the results

CodePudding user response:

reference 1st floor nayi_224 response:

 select decode (null, comm, 1, 2) from emp where comm & gt;=comm 

The results to see

CodePudding user response:

Like this?
Select * from emp t1 where t1.com m & gt; M=t1.com

CodePudding user response:

Are you sure save in comm is null, not '?

CodePudding user response:

reference nayi_224 reply: 3/f

so?
Select * from emp t1 where t1.com m & gt; M=t1.com

CodePudding user response:

reference 4 floor AHUA1001 response:

are you sure you remaining in the comm is null, not ',

Is null, comm field is number type

CodePudding user response:

Don't think so much, you can found out data doesn't explain anything, it is to look not to come out,