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
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>
> 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
> --
: 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
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--
---
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
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
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
root@fatcity. Subject: sql help --urgent
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
10 matches
Mail list logo