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.2 2544
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_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.1 2494
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON5 6932
I completed my B.tech (IT). Actually I want to develop virtual object that which will change software technology in the future. To develop virtual object what course I have to take. can I any professor to help me.697
What can be done if requirements are changing continuously?5 11668
Testing process in your company?1 5401
primary key is foreign key for the same table?2 3997
You have only one container full of water. You didnt have any marker or measurement device. Find the half of the container.3 6769
the bank revised the late payment penalty charges to $750 and to the borrowers A/C, pass the journal entry for the same1 7474
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?1 4548
while loading data into database how can u skip header and footer records in sql*loader1 3193
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently1 3536
While doing implementation,Client wants two use 2 Accounting methods for both Sandard Accrual method and Sandard Cash Method.So how we need to map or how need to provide solution.1 4568
How are dimensions optimized?
Can anybody explain what is the different between ESD & PLC
How to find weight of steel in kg if we know the area which is in m2? Following details are known to us, Area=125m² thk of slab=250mm Steel details:T12@200 PS:considering mesh top and bottom with X and Y direction
in sulfur process what is material of impulse line we use to connect with transmitter ? and does teflon affected by sulfur?
what is meant by life cycle of a business
Can anyone tell me, What is wound fixing?
hi if anyone have ntpc q previous year ...send me email@example.com
B.M DIAGRAMS & S.F DIAGRAMS OF CONTINOUS BEAMS
describe various plants nutrients under the following heading 1:phosphorus excessive supply/toxity 2:sulphur excessive supply/toxity 3:magnesium excessive supply/toxity 4:manganese excessive supply/toxity 5:iron excessive supply/toxity
In case of we are not saving the information as cookies. how server detects the same user?
what is the BAM? where we can use it in BizTalk server?
what is the future of ayurved in India.
What is pipelining and how can we increase throughput using pipelining?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
"What are sensible heat, latent heat, and specific heat of water?"