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
5962 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 do I quit sql?

899

Which table is left in join?

916

What is the difference between inner join and natural join?

956

How many clustered indexes can you have?

926

What is the size of partition table?

992

How many types of literals are available in pl sql?

1047

How do you optimize a stored procedure query?

939

Is pl sql better than sql?

982

Is pl sql useful?

934

Is left join same as join?

939

What are tables in sql?

999

What is rownum and rowid?

985

What is dense_rank?

879

How does sql store data?

867

How do I partition a table in sql?

1045