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 Answers
- 9580 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / mani
WITH a as (SELECT level L from DUAL CONNECT BY level <=3)
SELECT 1, L, R
FROM (SELECT level R from DUAL CONNECT BY level <=3) b
CROSS JOIN a;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between unique and primary key constraints?
Explain the difference in execution of triggers and stored procedures?
What is user defined functions?
Does access use sql?
Is primary key clustered index?
How many columns should be in an index?
Why is stored procedure faster than query?
What is primary key and foreign key with example?
What are sql functions? Describe the different types of sql functions?
Why are indexes and views important to an organization?
Is it possible to create the following trigger: before or after update trigger for each row?
What is the difference between join and natural join?
What is the use of partition by in sql?
how to drop an existing view in mysql? : Sql dba
What is pl sql package?
