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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinay
Select distinct trans_id,max(trans_amt) over (partition by
trans_id,debit_credit_indicator ),min(trans_amt) over
(partition by trans_id,debit_credit_indicator
),debit_credit_indicator from Customer
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is RAC in oracle?
What is assignment operator in pl sql?
What is union, minus and interact commands?
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
Why does %isopen return false for an implicit cursor?
How to change sql*plus system settings?
what is the command used to fetch first 5 characters of the string? : Sql dba
what is global table
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
In a package if we have 10 procedures or functions,How to know which will execute first?
What is trigger price?
how can create data base link for tow servers (scott schema) give examples plz