Re: SQL Help Urgent!!!!!!!!!

2002-05-13 Thread sultan
I got it.Thank you Gurus for your reply. Regards syed > > sultan wrote: > > > > Hi gurus > > > > I have two tables like this > > > > > > SQL> select * from bb; > > > > ID AMOUNT DT > > -- -- -- > > 1 1000

Re: SQL Help Urgent!!!!!!!!!

2002-05-12 Thread sree
will also try without using view .   Regards   Sreeraman   - Original Message - From: sultan To: Multiple recipients of list ORACLE-L Sent: Monday, May 13, 2002 10:53 AM Subject: SQL Help Urgent! Hi gurus   I have two tables like this     SQL>

Re: SQL Help Urgent!!!!!!!!!

2002-05-12 Thread Stephane Faroult
> sultan wrote: > > Hi gurus > > I have two tables like this > > > SQL> select * from bb; > > ID AMOUNT DT > -- -- -- > 1 1000 10-MAY-02 > > > > > SQL> select * from cc; > > ID AMOUNT > --

RE: SQL Help Urgent!!!!!!!!!

2002-05-12 Thread Vikas Khanna
: sultan [mailto:[EMAIL PROTECTED]]Sent: Monday, May 13, 2002 10:53 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Help Urgent! Hi gurus   I have two tables like this     SQL> select * from bb;       ID AMOUNT   

SQL Help Urgent!!!!!!!

2002-05-12 Thread sultan
Hi gurus   I have two tables like this     SQL> select * from bb;       ID AMOUNT     DT-- -- -- 1   1000  10-MAY-02         SQL> select * from cc;       ID AMOUNT-- ---

SQL Help Urgent!!!!!!!!!

2002-05-12 Thread sultan
Hi gurus   I have two tables like this     SQL> select * from bb;       ID AMOUNT     DT-- -- -- 1   1000  10-MAY-02         SQL> select * from cc;       ID AMOUNT-- --- 1

Re: sql help --urgent

2001-07-21 Thread Rangachari Sundar
Hi, Select a, decode(sign(a), -1, 0, a-1) from For summing up : sum(decode(sign(a), -1, 0, a-1)) Hope this helps Bye Sundar Ravindra Basavaraja wrote: > I have a table with a number column(Col A).I want to display A-1.There could > be some negative values in > this A-1 column.But I want t

RE: sql help --urgent

2001-07-20 Thread Michael E. Cupp, Jr.
select sum(column) where column > 0 or try a decode -Original Message- Basavaraja Sent: Friday, July 20, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I w

Re: sql help --urgent

2001-07-20 Thread Ron Thomas
root@fatcity. Subject: sql help --urgent

sql help --urgent

2001-07-20 Thread Ravindra Basavaraja
I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to h