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
6091 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 types of variable use in pl sql?

1012

What is database white box testing and black box testing?

1050

What is serial sql?

923

Why we use pl sql?

909

What does varchar include?

908

Is t sql a programming language?

1008

How do I remove sql developer from windows 10?

1016

Which is faster view or stored procedure?

889

Why left join is used in sql?

919

How bulk collect improves performance?

951

What is asqueryable?

905

what are enums used for in mysql? : Sql dba

1114

What is sql indexing?

966

How many types of triggers are there in pl sql?

1017

How do I remove sql plus from windows 10?

1030