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
6306 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 is the difference between rename and alias?

1390

What is the difference between a database and a relational database?

1155

Write a sql query to find the names of employees that begin with ‘a’?

1057

What are types of joins?

1026

Is sql a programming?

1026

What are sql constraints?

1226

Why do we go for stored procedures?

1126

what is a control file ? : Sql dba

1089

What are different categories of sql commands?

1194

explain access control lists. : Sql dba

1048

Mention what does plv msg allows you to do?

1162

What is sql architecture?

1102

Can you select everything, but 1 or 2 fields, without writer's cramp?

1037

what is dbms? : Sql dba

1035

What is scope and visibility in PL/SQL?

1289