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
6232 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 natural join in sql?

1044

Is id a reserved word in sql?

1187

What is rowid in sql?

1055

Write an sql query to select all records from the table?

1079

how many columns can be used for creating index? : Sql dba

987

What is ttitle and btitle?

1114

Explain the uses of a database trigger?

1087

What is union?

1251

Is sql a dbms?

1062

Can we insert in view in sql?

1106

What are the parameter modes supported by pl/sql?

1154

What are the three forms of normalization?

1092

What is mdf ldf and ndf?

1058

Why is sql*loader direct path so fast?

1141

What is trigger in pl sql with examples?

1082