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 2673
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 2628
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 7147
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.738
What can be done if requirements are changing continuously?5 12133
Testing process in your company?1 5554
primary key is foreign key for the same table?2 4131
You have only one container full of water. You didnt have any marker or measurement device. Find the half of the container.3 7004
the bank revised the late payment penalty charges to $750 and to the borrowers A/C, pass the journal entry for the same1 7659
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?1 4674
while loading data into database how can u skip header and footer records in sql*loader1 3348
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently1 3671
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 4686
Dear Sir, My qus is my co. purchase a laptop from Abc.co. for rs-37200 on credit Emi basis from hdfc bank. i paid every month 6200rs as a installment. so i want to know how i make a entry in tally 9. and also want to know i creat laptop ledger under fixed assets or office expenses. plz tel me soon.or mail me .
From the following find out a. Profit Volume ratio b. Break even point c. Sales for 40% P/V Ratio d. Margin of safety from the sales Rs 3,00,000 e. Net profit from the sales of Rs 3,00,000 f. Required sales for the new profit of Rs 70,000 g. Required sales for the net profit of Rs 70,,000 after tax, the corporate income tax being 40% h. Additional sales required to convert an increase of Rs 3000 p.a. in the sales manager salary Sale 2,00,000 Variable Overheads 1,50,000 Profit 50000 Fixed overheads 15000 Net profit 35000 Sl No Heads of Account Debit Rs Credit Rs 1 Drawing and Capital 750 15,000 2 Stock as on 01.01.2009 69720 3 Bills Receivable and bills payable 1000 1180 4 Returns 300 320 5 Purchases and Sales 4500 8300 6 Wages 70 7 Discount 30 8 Salaries 200 9 Canara Bank Shares 3000 10 Insurance 120 11 Building 3000 12 Furniture 700 13 Debtors and Creditors 600 1300 14 Cash in Hand 470 15 Overdraft at bank 900
What will your outlook towards maintenance of liquid assets to ensure that the firm has adequate cash in hand to meet its obligations at all times
"What do you do when in your duty, ME alarm oil mist detect high density?"
Why do you need to parameterize fields in your virtual user script?
What is overhauling and record kelping? What is the prosecute of dismantling and assembling?
and gate circuit diagram,amplifier circuit diagram
How would you go about persuading a customer that our product was better than any other?
What is the use of SOCK_STREAM Socket Type?
How to Get a list of the available drives on a system?
Hi Friends, Just One Month Back I was Join in Small Company as a Testing Eng.I have Six Month Exp. In this Company all my team memb.r fresher & PM give responsibility on us to prepare all require QC doc. for our new project.So I need ur help in this matter .How Can I start my work and Which Doc.I start to collect & From Where I get Detail Information all abt these thing. Thanks to all friends who give reply to this. Suyog
Hello.. i have a question. which signature digital or signature logo we use in smartforms & scripts...? if we use digital sign what are those steps to use it...?
what is the pulse and audio frequency transformer? what is different between induction regulators and tap changing transformer?
Automatic clearing Ib OB74 based on criteria I have defined document type and account no. and whether it cleared automatically or we have to go to F.13 do test run after that we will clear the document
What is the advantage of Ring network ? Compare it with ethernet