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
10507 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 data control language? : Sql dba

1017

Can we create index on primary key?

958

what is meant by urlencode and urldocode? : Sql dba

1167

Why use subqueries instead of joins?

1072

what are aggregate and scalar functions? : Sql dba

1051

Is sql better than access?

1006

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1132

What is a primary key? Explain

968

Can we create clustered index without primary key?

955

how are mysql timestamps seen to a user? : Sql dba

1123

Explain the difference between rename and alias?

1010

What is data definition language?

1085

How does sql*loader handles newline characters in a record? : aql loader

1036

how to start mysql server? : Sql dba

1192

What are the two characteristics of a primary key?

965