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 5956Post New i2 Interview Questions
What is url routing?
Hi all.... Please explain to me... what G/L account should I maintain / create If I want to do the intercompany transfer asset - no revenue. and if I want to do the intercompany transfer asset - Net Book Value. What is the different between this 2 method. My company's requirement is ... 1. Transfering the asset on company A to company B, example Asset 1 - acquisition date : 01.06.2007 , acquisition amount : 1000, accumulated depreciation till 31.12.2007 : 10 so the net book value is 90, useful life 4 years the company wants to transfer this asset in company B. is it possible to transfer all the data just like I explain above : acquisition date : 01.06.2007 , acquisition amount : 1000, accumulated dep = 10
What is the shortcut to add a row to a table in word?
What is structure and union in c?
What are the advantages of using shell scripts?
What are components life-cycles?
Explain the purpose of %type and %rowtype data types with the example?
Is xpadder free?
What are the advantages of using jsx?
How do you declare an array that will hold more than 64KB of data?
Why is it important to cross reference?
What is the difference of counting(t556c) and counting class (Absence valuationT554c). Similarly, difference of cumulation and wagetype cumulation?
What are the two ways to include the result of another page?
Which is the largest comet?
What is open database communication (odbc) in oracle?