SELECT 1, L, R FROM (SELECT LEVEL R FROM DUAL CONNECT BY LEVEL<=3), (SEL

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 / abilash reddy

3 Answers
10464 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / abilash reddy

SELECT 1, L, R FROM (SELECT LEVEL R FROM DUAL CONNECT BY LEVEL<=3), (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL<=3);

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of <> sql?

959

How can I speed up sql query?

935

How show all rows in sql?

997

What is the reports view in oracle sql developer?

954

How does a self join work?

1075

What are the types of keys?

980

What are the disadvantages of not performing database normalization?

1144

What is the requirement of self-join?

1098

what are the drivers in mysql? : Sql dba

1006

Is sql a backend?

1002

What is %type in sql?

947

When should I use nosql database?

985

What does closing a cursor do?

1301

Is sql injection illegal?

1003

What are primary key and foreign key and how they work?

960