select trans_id,debit_credit_indicator,max(trans_amount),min(trans

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.

Question Posted / prativa mishra

2 Answers
6222 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / prativa mishra

select
trans_id,debit_credit_indicator,max(trans_amount),min(trans_am
ount) from customer1
group by trans_id,debit_credit_indicator
order by trans_id

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the events on which a database trigger can be based?

1195

What is microsoft t sql?

951

What are triggers in sql?

1025

What is clustered and nonclustered index in sql?

945

What is number function in sql?

980

How to create your own reports in sql developer?

1027

How do you modify a trigger?

930

What is native sql query?

1027

What is null in pl/sql?

1077

Is join and inner join the same?

1011

Define union, minus, union all, intersect ?

1012

What is basic structure of pl sql?

1075

What is pl sql block structure?

1044

What are aggregate functions in sql?

1166

Is it possible to create startup or shutdown trigger for on-schema?

1036