GeekInterview.com
Series: Subject: Topic:
Question: 205 of 213

State true or false. !=, <>, ^= all denote the same operation.

True

Asked by: Interview Candidate | Asked on: Mar 6th, 2005
Showing Answers 1 - 20 of 20 Answers
muthu

Answered On : Sep 19th, 2005

true

  
Login to rate this answer.
Pushpendra Rana

Answered On : Sep 26th, 2005

FALSE

  
Login to rate this answer.
balwant

Answered On : Sep 28th, 2005

this is true

  
Login to rate this answer.
kk

Answered On : Oct 4th, 2005

True.

Boss Pushpendra,answer only if u r sure.

Yes  1 User has rated as useful.
  
Login to rate this answer.
Anuradha

Answered On : Oct 13th, 2005

ans:

 false

Because: If we will consider only SQL operators  Only <> is the operator.

  
Login to rate this answer.
Sonu

Answered On : Jan 10th, 2006

Its False because SQL supports operator is only <>

Yes  1 User has rated as useful.
  
Login to rate this answer.
sonu

Answered On : Jan 10th, 2006

Its true

  
Login to rate this answer.

true

  
Login to rate this answer.
Muthurp

Answered On : Mar 24th, 2006

It is False. ^= does not work in SQL

Yes  2 Users have rated as useful.
  
Login to rate this answer.
vinnu

Answered On : Oct 12th, 2006

This is True

  
Login to rate this answer.
mehraban_b

Answered On : Mar 14th, 2007

View all answers by mehraban_b

False --> The Only Operator that works in SQL and means "not equal to"  is  " <> "

  
Login to rate this answer.
Ravi Savaliya

Answered On : Apr 6th, 2007

Only <> and != works for not equal sign , there is no operator like ^=

  
Login to rate this answer.
kvk817

Answered On : Apr 24th, 2008

View all answers by kvk817

hey friends......
bee cool....if u knopw answer just tell other wise donot make rubbish to fool others...

see the statment;
select * from dept where dept != 20;
select * from dept where dept <> 20;
select * from dept where dept ^=20;
the query works for all

its true;;;;;;
byeeeeeeeeeeeeeeeeeeeeeeeeeeeee

Yes  3 Users have rated as useful.
  
Login to rate this answer.
chaitanya_m03

Answered On : May 23rd, 2011

View all answers by chaitanya_m03

SQL> Select 2+2 From dual Where 5 ^= 9; 2+2 ---------- 4

SQL> Select 2+2 From dual Where 5 <> 9; 2+2 ---------- 4

SQL> Select 2+2 From dual Where 5 != 9; 2+2 ---------- 4

SQL> Select 2+2 From dual Where 5 ^= 5; 2+2 ----------


Guys its TRUE....3 operators work the same way.....NOT EQUAL TO

  
Login to rate this answer.
yuvaevergreen

Answered On : Jun 14th, 2011

View all answers by yuvaevergreen

yes in teradata

  
Login to rate this answer.

<> and != works fine but, there is no operator like ^=

  
Login to rate this answer.
Amit dass

Answered On : Oct 28th, 2011

True All Represent NOT EQUAL TO

Code
  1.  

  
Login to rate this answer.
Aashu

Answered On : Feb 3rd, 2012

^= operator is a Bit wise Exclusive OR operater in MS SQL.
It stands into category of compound operators and performs a bitwise exclusive OR and sets the original value to the result.

  
Login to rate this answer.
Durgesh Kumar Singore

Answered On : Feb 7th, 2012

In SQL 2005 only != and <> operator perform same operation

^= does not work

  
Login to rate this answer.
Guru

Answered On : Dec 19th, 2012

True

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.