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.
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 foreign key and example?
does sql support programming? : Sql dba
Does inner join remove duplicates?
What are the qualities of 2nf?
What are the built in functions of sql?
Can sql developer connect to db2?
What is procedure and function in sql?
What schema means?
How do you delete duplicates in sql query using rowid?
What is gpt format?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the reports view in oracle sql developer?
What is sequence in sql?
Write a query to display the current date in sql?
What is sql table?