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
10549 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

Explain the uses of a database trigger?

1045

Does google use sql?

969

What is the requirement of self-join?

1133

What is pl sql quora?

1176

What is the purpose of a secondary key?

979

what are the advantages of using stored procedures? : Sql dba

1105

what is the functionality of the function htmlentities? : Sql dba

970

Mention what is the function that is used to transfer a pl/sql table log to a database table?

997

Why is partition used in sql?

1130

how mysql optimizes distinct? : Sql dba

1083

Explain dml and ddl?

1004

What does (*) mean in sql?

955

Can we call a function containing dml statements in a select query?

988

what is the different between now() and current_date()? : Sql dba

1027

What is sql select statement?

1037