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 9250source 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 10274what is the difference between keys.enter and keys.return in selenium? i have used both and both performed enter.
1 6538i 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 3314What 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 7261While 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 ?
1818How 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?
898Mention 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.)
923Post New JPMorgan Chase Interview Questions
What is the mainframe testing?
how will xml affect my document links?
What are child selectors??
how server differentiate different clients ie if you r using http application server listen through port 80 if all client using same http application then how?
Explain about obj-open, obj-save?
What is Twisted Pair ?
Why in open-wheel racing cars torsion bars (of suspensions) are removed in case of wet track?
Write the instr function.
How we can fire the query in web sql?
Explain the Architechture of SRE and JCAPS.
PostgreSql Disadvantages
How can you use check constraints for self referential integrity?
please e-mail me the model of Tamil Nadu drug inspector question papers
What is the full form of linux and unix?
What is sizeof in c?