Interested to Buy Any Domain ? << Click Here >> for more details...
i have a customer table.
trans_id trans_date trans_amt debit_credit_indicator
001 01-JAN-13 1099 cr
001 12-JAN-13 500 db
002 24-FEB-13 400 db
002 23-MAR-13 345 cr
001 18-APR-13 800 cr
002 15-MAR-13 600 db
001 12-FEB-13 200 cr
i want like this output.
trans_id trans_amt debit_credit_indicator
i want get highest credit amount and lowest credit amount
and highest debit amount and lowest debit amount for each
trans_id.
- 2 Answers
- 6309 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / ajit
select ac_no, max(AC_STATUS) high,min(AC_STATUS) low,ac_branch
from DIM_ACCOUNt
where ac_branch = 'cr'
and ac_no = 1
group by ac_no, ac_branch
union
select ac_no, max(AC_STATUS) high,min(AC_STATUS) low,ac_branch
from DIM_ACCOUNt
where ac_branch = 'cr'
and ac_no = 2
group by ac_no, ac_branch
union
select ac_no, max(AC_STATUS) high,min(AC_STATUS) low,ac_branch
from DIM_ACCOUNt
where ac_branch = 'db'
and ac_no = 2
group by ac_no, ac_branch
union
select ac_no, max(AC_STATUS) high,min(AC_STATUS) low,ac_branch
from DIM_ACCOUNt
where ac_branch = 'db'
and ac_no = 1
group by ac_no, ac_branch;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I know if I have sql express or standard?
What is the location of pre_defined_functions.
What is meant by user defined function?
What is a database event trigger?
What is primary key in db?
what is the difference between char and varchar data types? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
Mention what are the benefits of pl/sql packages?
What is the current version of sql?
How many sql databases can you have on one server?
Can ddl statements be used in pl/sql?
What is a sql profiler?
How do you write a subquery?
Why are cursors used?
Is sql harder than python?
