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
6227 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 to rename a column in the output of sql query?

1121

What is a ddl command?

1151

How do I delete a trigger?

1013

what are the 'mysql' command line options? : Sql dba

1128

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7476

What are % type and % rowtype?

1079

How to know the last executed procedure?

1153

Why we use cross join?

997

What is delimiter sql?

1058

What is nosql vs sql?

1224

How do I create a sql script?

1140

What is Collation Sensitivity ? What are the various type ?

998

What is sql data?

1032

Can ddl statements be used in pl/sql?

1188

Which command is used to delete a package?

1230