Simple, must be simple :)

Peterpeter · #1 (**permalink**) 10-26-05, 07:27

Need for help

simple query

select docsum, agent
from tb1

so far so good

but now is need for one more column (the third one), where docsum >500
Please, any suggestions

madafaka · #2 (**permalink**) 10-26-05, 10:32

specify clearly what you need:

1) Select just rows where docsum > 500

2) Select all rows but display docsum only for these rows where docsum > 500?

In first case use:

Code:

select docsum, agent
from tb1
where docsum > 500

In second case, you can use more options depends on database server e.g. on oracle:

Code:

select 
case when docsum <= 500 then
 null
else
 docsum
end docsum,
agent
from tb1

Peterpeter · #3 (**permalink**) 10-27-05, 03:57

Thank`s madafaka, the second case i was looking for

Internet Services

Web Development

Digital Marketing

Consumer Tech