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
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
Is primary key always clustered index?
How to run sql statements through the web interface?
What are the syntax and use of the coalesce function?
Why do we use procedures?
What is pivot table in sql?
Can we write ddl statements in functions?
What is a memo field?
What is a rank in sql?
What is the difference between sql and t sql?
What schema means?
Is sqlite free?
Why is pl sql needed?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is the life of an sql statement?
Why do we go for stored procedures?