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
- 9827 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
Can you upgrade sql express to full sql?
What is left inner join in sql?
Can we use ddl statements in stored procedure?
Write a unique difference between a function and a stored procedure.
What is clustered index in sql?
What type of database is sql?
How many indexes can be created on a table in sql?
what is an extent ? : Sql dba
Can we perform dml in function?
What normalization means?
Can you join views in sql?
What is foreign key and example?
Is nosql faster than sql?
What are triggers in sql?
What are different sql data types?
