Results 1 to 3 of 3

Thread: Operators in SQL

  1. #1
    Junior Member
    Join Date
    May 2006
    Answers
    9

    Operators in SQL

    !=, <>, ^=

    In SQL, do all these operators do the same thing? Please explain your answer.


  2. #2
    Junior Member
    Join Date
    Apr 2006
    Answers
    24

    Re: Operators in SQL

    Yes, all of them work in ORACLE.
    why don't you try it on your own?

    Patrick.


  3. #3
    Contributing Member
    Join Date
    May 2006
    Answers
    82

    Re: Operators in SQL

    The operator used in SQL for not equal is only <>. The syntax for that is

    Formula1 <> Formula2

    Explanation:
    Is TRUE when the value at the left side of the operator is not equal to the value at the right side?

    Example:
    SELECT s1, s2, s3
    FROM table1
    WHERE s1 <> 0;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact