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 / prativa mishra

3 Answers
6238 Views
I also Faced
E-Mail Answers

Answer Posted / prativa mishra

SELECT trans_id,MAX(TRANS_AMOUNT),MIN(TRANS_AMOUNT),DEBIT_CREDIT_INDICATOR
FROM CUSTOMER
GROUP BY TRANS_ID
,DEBIT_CREDIT_INDICATOR
ORDER BY TRANS_ID

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how can we know the number of days between two given dates using mysql? : Sql dba

1089

What are the different types of sql commands?

1179

What is the difference between delete, truncate and drop command?

1228

What is trigger in pl sql with examples?

1082

What is a field in a database?

1104

How can you fetch first 5 characters of the string?

1068

What is pls_integer in pl sql?

1158

Why are indexes and views important to an organization?

1000

What is an oracle stored procedure?

1117

Can we use insert statement in function?

1047

What are analytical functions in sql?

1080

Is primary key always clustered index?

1066

What is acid property in a database?

1086

Why do we need view in sql?

1039

What are the most important ddl statements in sql?

1189