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.
Answer Posted / prativa mishra
select
trans_id,debit_credit_indicator,max(trans_amount),min(trans_am
ount) from customer1
group by trans_id,debit_credit_indicator
order by trans_id
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is difference between my sql and sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is delete command in sql?
What company owns postgresql?
How do you explain an index?
What is example of database?
how to shut down the server with 'mysqladmin'? : Sql dba
how to get a list of all tables in a database? : Sql dba
What is update query?
How can we debug in PL/SQL?
When is the update_statistics command used?
When is the explicit cursor used ?
What operators deal with null?
Why self join is used in sql?
how to concatenate two character strings? : Sql dba