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
5959 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

What is error ora-12154: tns:could not resolve the connect identifier specified?

1015

How does pl sql work?

912

What is a native sql query?

972

Why is the cursor important?

976

Is join and inner join the same?

940

What is sqlite used for?

933

Are null values same as that of zero or a blank space?

966

What are the different types of constraints?

1071

What is number function in sql?

912

Mention what does plv msg allows you to do?

1053

What are tables and fields in the database?

1023

What is a variable in sql?

949

Is not null in sql?

926

What are the advantages of normalization?

1038

What is compilation error in pl sql?

920