explain these select statements!

Posted by user329820 on Stack Overflow See other posts from Stack Overflow or by user329820
Published on 2010-04-30T16:22:32Z Indexed on 2010/04/30 16:27 UTC
Read the original article Hit count: 239

Filed under:
|

Hi, I can not get the difference betwwn these statements? would you please help me,I have read some sample of select statements but I did not get these ones.

SELECT 'B' FROM T WHERE A = (SELECT NULL);
SELECT 'C' FROM T WHERE A = ANY (SELECT NULL);    
SELECT 'D' FROM T WHERE A = A;

I use MySQL

© Stack Overflow or respective owner

Related posts about database

Related posts about sql