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

What is trigger explain it?

1020

Explain what is sql?

1119

what are the advantages of mysql in comparison to oracle? : Sql dba

1007

How do I run a pl sql procedure in sql developer?

976

Mention what is the plv (pl/vision) package offers?

1108

How do I copy a table in sql?

995

Which is the correct statement about truncate and delete?

1116

Is coalesce faster than isnull?

969

What is the difference between sum and count in sql?

989

What is meant by cursor in sql?

1007

What is the size of partition table?

1048

What is partition by in sql?

1074

What is join view in sql?

949

what is union? : Sql dba

1033

Explain the purpose of %type and %rowtype data types?

935