can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3
2 5060Post New i2 Interview Questions
Ganesh & Gopal joined a firm drawing salary of Rs 25000 per month.After serving 3 yrs ,they started business of their own in partnership,contributing Rs200000(expected life 10 yrs,bought spare parts worth Rs 33000 from Kundu on credit.Office supplies were purchased for cash.Initially they were very busy in conducting their business operations but by the end of the 1st year,31/12/2005 they were disappointed when they found their bank balances.Following is the summary of their bank statement. Receipts: Share Capital Rs 250000 Collections from Customers 412000 Payments: Equipment 200000 Salaries of Assistants 88000 Rent advance for 2 yrs 96000 On-year ins. Policy on equipment 12000 Office stationery 27000 Payment to Kundu 29000 Withdrawals of Ganesh 90000 Withdrawals of Gopal 90000 Closing balance c/d 30000 ----------- Total : 6,62,000 Still amount receivable from customers for services to them amounted to Rs 30,000 & closing balance of office stationery is Rs2000,spare parts Rs2600 were utilised by the end of the year .Prepare trial balance with the available information and show total. Also what is the net profit.
What are the different ways of data parametrization in jmeter?
What are adwords?
Which event is triggered when mouse focus comes out of an element in the vbscript language?
Is it possible to list only a portion of Equity Shares leaving the balance as unlisted?
Define hybrid parameter?
How to use filtering in xslt? : xslt
what is an extended stored procedure? : Sql server database administration
Is objective c hard to learn?
How do you sort a sort function in c++ to sort in descending order?
Why Salesforce is important?
which is the most advanced form of SF6 BREAKER?Can we use other gases to quench the arc?
Explain teradata utilities. What is multiload, fast load, tpump?
How to configure git post commit hook?
What does it cost?