difference between <>and !=

[jntuian]

Hi,

a)how it affects the sql query when used <> and !=
b) when shud we use <> and !=
c) Does it affects the performance

[DaPi]

They behave identically. (I think <> looks nicer - so I use that!)

[onlysimon]

'!' is a long way away from '=' on my keyboard, whereas <> are right next to each other...

so that makes select count(9) from foo where bar <> 0 a damn efficient statement.

[slimdave]

Originally posted by onlysimon
so that makes select count(9) from foo where bar <> 0 a damn efficient statement.

I _knew_ there was a reason why count(9) was more efficient than count(1). That's it!

[kris109]

No difference.

[Tarry]

None