SELECT trans_id,MAX(TRANS_AMOUNT),MIN(TRANS_AMOUNT),DEBIT_CREDIT

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 / srinu.g

3 Answers
6059 Views
I also Faced
E-Mail Answers

Answer Posted / srinu.g

SELECT
trans_id,MAX(TRANS_AMOUNT),MIN(TRANS_AMOUNT),DEBIT_CREDIT_INDICATOR
FROM CUSTOMER WHERE DEBIT_CREDIT_INDICATOR='cr'
UNION ALL
SELECT
trans_id,MAX(TRANS_AMOUNT),MIN(TRANS_AMOUNT),DEBIT_CREDIT_INDICATOR
FROM CUSTOMER WHERE DEBIT_CREDIT_INDICATOR='db'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how does a local variable is defined using t-sql? : Transact sql

987

what is myisam? : Sql dba

1054

how to get @@error and @@rowcount at the same time? : Sql dba

1008

How do I create a memory optimized filegroup?

944

explain the difference between delete , truncate and drop commands? : Sql dba

1073

difference between anonymous blocks and sub-programs.

1120

Does pl/sql support create command?

1086

How does one use sql*loader to load images, sound clips and documents? : aql loader

1162

How do I make my sql query run faster?

918

Can we call stored procedure in function?

938

What is an intersect?

1087

What is a recursive stored procedure?

1158

How to select unique records from a table?

1037

What does inner join mean?

1140

What is the location of pre_defined_functions.

1150