| |
| |
| |
|
Comments:
<0> - I want to believe.
<1> hi folks
<1> anyone alive?
<1> I want to make a select statement and compare two amounts together to see if we have a difference of 1.00 dollar.. if yes, list them.
<2> select a,b from t where (a-b) = 1
<3> hmm
<4> difference bigger and smaller as 1 dollar
<4> <> 1.00 dollar
<0> Guest33947 : A nickname would be nice =)
<4> yep, sorry for that.
<0> np
<5> there we go ;-)
<0> u want to select the ones which are not 1$ ?
<0> <> 1.00 dollar <---
<0> maybe (a-b) <> 1 ^^
<0> <---- using mySQL for a customer, since I can't use MSSQL2k5 other than internal use because of my Action Pack License
<0> :<
<5> ok, let me rephrase:
<5> I want to compare A(100.00$) with B(101.10$) to see if there is a difference bigger than 1.00$.. (true in that case). another example: A(100.00), B (100.50).. shouldn't be listed since it's under 1.00$
<6> aah
<6> hmmn
<5> i'm using oracle db, btw.
<6> perhaps.. " where ( ((a-b)>1) OR ((b-a)>1) ) "
<6> too bad "jackfig" isn't online right now, he is the Oracle guru around here.
<5> okiedokely
<5> let me try it..
<6> that should work.
<5> thx anyway..
<6> np
<6> I'm a bit drunk from vodka so...
<6> hehe
<5> i gotta create me some data before I can test it anyway
<6> AND am 2 work :p
<6> @
<6> yeah, it's always easier with data ;)
<5> np.. know that feeling.. but being drunk at work would be bad for me
<5> bl
<5> bbl
<6> * AcIdLi (acidli@staff.dalnet)
<6> O.o
<2> i ****ing hope not, or we are all doomed
<6> hehe
<6> http://video.google.co.uk/videoplay?docid=6860946590182985661
<6> good video
<7> in GridView (asp.net) + SQL how to show only 5 first characters? -> http://img149.imageshack.us/img149/8954/imgzy6.gif
<8> Anybody tell me how to Install the tables from a file named allgamesbackup.sql"
Return to
#sql
or
Go to some related
logs:
#kl
#linux
#allnitecafe
#kl
#allnitecafe
quote was liebt das neckt
#chat-world
#india
MBE_
#india
|
|
