Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
3 10371source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
4 11813what is the difference between keys.enter and keys.return in selenium? i have used both and both performed enter.
1 7392i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
1 3928What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
4 8614While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
2280How to you define your goals in life? Do believe in making plans and strategies for the future or believe in grabbing opportunities as they come?
1322Mention any three good or bad qualities that your friends would tell us about you. How accurate do you think they are in their observations? (If Yes or No, please explain why.)
1335Post New JPMorgan Chase Interview Questions
What the major difference between rpa and macros?
What is the use of internet addresses?
How does pipe () work?
Short Answer on __________Measurement
How many types of keys are there in keyboard?
What is a join? Explain the different types of mysql joins.
What do you see as the key strengths of a business analyst?
I have an span length 16 ft c/c
Is buffer size and file block size is similar? If similar,at which case it will be same size?
What is the difference between weblogic and tomcat?
What are the electro cardiogram findings of a mobitz type ii second degree av block?
What is the use of httpservletresponsewrapper?
Sort of popular rpa tools?
Which methods of python are used to determine the type of instance and inheritance?
What is use of scriptlet tags in jsp?