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 5972Post New i2 Interview Questions
Define what is special about the properties of chromium molybdenum steels that make them ideal for pressure vessels?
Suppose you're tasked with designing a new integration scenario. How would you assess the requirements, design the solution, and ensure its optimal performance in SAP Process Orchestration?
How do you make a white background transparent in powerpoint?
What is render() in React? And explain its purpose?
What is Spark Core?
THERE iS ANY DEFAULT CONNECTION STRING FOR WINDOWS APPLICATION IN VB.NET2005 FROM WHICH AFTER CHANGING PROJECT DIRECTORY TO OTHER PLACE AND WE DID NOT CHANGE DATABASE PATH INB SQL CONNECTION ?????
What are action tags?
Why do we need mapping in hibernate?
When a thread blocks on i/o?
How is hadoop different from other data processing tools?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the ways to access hibernate by using spring?
Difference between depreciation according to cost principle and matching principle
What are the relays in ACB and VCB
What are arithmetic operators?