WITH a as (SELECT level L from DUAL CONNECT BY level <=3) SELECT 1, L,

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.

Question Posted / mani

3 Answers
10466 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

Please Help Members By Posting Answers For Below Questions

What is foreign key and example?

916

does sql support programming? : Sql dba

1028

Does inner join remove duplicates?

930

What are the qualities of 2nf?

1022

What are the built in functions of sql?

1014

Can sql developer connect to db2?

1012

What is procedure and function in sql?

971

What schema means?

874

How do you delete duplicates in sql query using rowid?

925

What is gpt format?

927

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1108

What is the reports view in oracle sql developer?

954

What is sequence in sql?

987

Write a query to display the current date in sql?

1004

What is sql table?

950