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 10661source 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 12168what is the difference between keys.enter and keys.return in selenium? i have used both and both performed enter.
1 7612i 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 4065What 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 8984While 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 ?
2387How 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?
1422Mention 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.)
1421Post New JPMorgan Chase Interview Questions
What is the base for DLNA?
SAP fico APP ISSUE( FOR PAYMENT METHOD "X" WE HAVE " PAYMENT PER DUE DAY" CHECK BOX CHECKED. AND WHEN RUNNING THE PROPOSAL 2 invoicecs[ 1) KR 2) RE] both having same due date and picking in two different proposals ...? is there any setting in app for document type wise payment?
Please explain what is the meaning of competitive analysis?
What is subtree?
How would you lock a table in sybase? What text command will you use for it?
What is the ratio of grades m5, m7.5, m10, m15, m20, m25, m30, m35, m40?
What are tabs in excel?
Expand-------SNAT
What is gradle android?
What are the different elements of event tracking in google analytics?
What do you mean by component versionig?
What is a decimal c#?
explain the mixture requirement of si engine to meet the demands of various operating condition?
how text is determined in Invoice,What are tools used in To_be study
What are the asp objects?