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 2618
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 2576
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 7052
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.720
What can be done if requirements are changing continuously?5 11977
Testing process in your company?1 5479
primary key is foreign key for the same table?2 4069
You have only one container full of water. You didnt have any marker or measurement device. Find the half of the container.3 6902
the bank revised the late payment penalty charges to $750 and to the borrowers A/C, pass the journal entry for the same1 7583
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?1 4609
while loading data into database how can u skip header and footer records in sql*loader1 3282
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently1 3598
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 4635
what are constructors and destructors?
differences between qtp10.0 and 11.0 ?
I got an offer from TCS as a software engineer, But it says I will work for TCS BPO, Is there any difference in policies of TCS BPO and TCS-IT Services.How is the Working enviornment and appriasal procedure
How to start up the interview for Team leader or Assistant Manager position
why top layer of block work shoud be full size if any cut block adjustable than another layer?
In loading programs into memory, what is the difference between load-time dynamic linking and run-time dynamic linking?
Describe of production processes, quality, stock control and factors internal and external that effect production within the organisation?
How to display seconds, minutes, tracks of an AVI ?
What is gtsc technology?
In conventional breeding within species, it is said that "vertical transfer" of genes takes place. However, biotechnology allows "horizontal transfer" of genes across species. Isn?t such horizontal transfer unnatural, and therefore possibly unsafe, as well as unethical?
y u looking for a job in it field sinc u r a ece graduate.
Is cnc operating experience is must for successful career in cad/cam?How to make salary jump in this field of cad/cam?
What is the basic difference between Modbus and CAN Open Protocols
What is the method of soil replacement test?
numerical on PCM.