DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Sql Commands

  1. #1
    Join Date
    Mar 2001
    Posts
    54
    Any one can help me out to find the differences between the SQL Command Operators

    =, in,any




    Can u tell me some web sites to find these type of help for SQL Commands(Advanced)




    Thankx
    M.Jeyaseelan

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    =
    Simple equality operator, returns TRUE if the left and the right side of the expression are identical. I'm sure everyone knows its meaning, but here is an example anyway:
    SELECT * FROM emp WHERE ename = 'ADAMS';

    IN
    Returns TRUE if the left side is identical to at least one member of the list on the right side.
    SELECT * FROM emp WHERE ename IN ('ADAMS','KING');

    ANY
    It is used in conjunction with (non)equality operator ("=ANY", ">=ANY", "!=ANY"). Reterns TRUE if left side of the expression meets the condition in at least one element from the right side list of vaues.

    Examples:
    SELECT * FROM emp WHERE ename =ANY ('ADAMS','KING');
    is the same as
    SELECT * FROM emp WHERE ename IN ('ADAMS','KING');

    SELECT * FROM emp WHERE sal <= ANY (SELECT sal FROM emp WHERE deptno=20);
    is the same as
    SELECT * FROM emp e WHERE EXISTS (SELECT NULL FROM emp WHERE deptno=20 AND e.sal <= sal);
    and (functionaly, not how it is executed) as
    SELECT * FROM emp WHERE sal <= (SELECT MAX(sal) FROM emp WHERE deptno=20);

    Among the less frequently used operators are also SOME (identical meaning as ANY) and ALL (the opposite of ANY/SOME). ANY, SOME and ALL are rearly used, although they are part of SQL standard. We are much more acquainted to use the combination of other frequently used operators (like IN and EXISTS) instead of them.

    All those operators are described in Oracle SQL Reference manual, available also on the web, for example on the technet.oracle.com

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Posts
    54
    Thank u very much jmodic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width