Select distinct trans_id,max(trans_amt) over (partition by 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.

pls give me answer. i want urgent

Question Posted / vinay

3 Answers
6118 Views
I also Faced
E-Mail Answers

Answer Posted / vinay

Select distinct trans_id,max(trans_amt) over (partition by
trans_id,debit_credit_indicator ),min(trans_amt) over
(partition by trans_id,debit_credit_indicator
),debit_credit_indicator from Customer

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is data stored on a disk?

1041

Do we need commit after truncate?

1088

What is a temporal data type?

1055

What is character functions?

1066

How do I run a sql trace?

964

What is exit statement?

1020

Differentiate between sga and pga.

1168

What is triggering circuit?

1073

What is sql table?

978

Difference between truncate, delete and drop commands?

1088

How do you update a table in sql?

993

what is msql? : Sql dba

994

Is big data nosql?

957

Which is faster view or stored procedure?

948

What is sql basics?

1046