Results 1 to 3 of 3

Thread: Operators in SQL

  1. #1
    Junior Member
    Join Date
    May 2006

    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

    Re: Operators in SQL

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


  3. #3
    Contributing Member
    Join Date
    May 2006

    Re: Operators in SQL

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

    Formula1 <> Formula2

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

    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.