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 10405source 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 11845what is the difference between keys.enter and keys.return in selenium? i have used both and both performed enter.
1 7431i 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 3940What 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 8664While 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 ?
2301How 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?
1339Mention 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.)
1348Post New JPMorgan Chase Interview Questions
What are the benefits of laravel?
What is ipc message?
What is a hive in big data?
How do Generative AI models create synthetic data?
Why is the importance of a consistent style?
What is the need for jsp?
What Are The Joint Supervisory Teams?
Tell me how much statistics knowledge is necessary or required in accounting?
What is a work process?
What is the usage of "i-am-a-dummy" flag in mysql?
What database should I learn first?
How was NSA involved in the design of DES?
Explain what is the difference between native sql and cognos sql?
What is a white noise model and how can you simulate it using r?
Is there a case wherein other qualifiers in multiple resources take precedence over locale?