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
10516 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 forward declaration in pl sql?

1071

What are the benefits of triggers?

1164

how is myisam table stored? : Sql dba

1050

The select into statement is most often used to create backup copies of tables or for archiving records?

1062

How many triggers can be applied on a table?

928

Define SQL and state the differences between SQL and other conventional programming Languages?

1206

what is 'mysqlshow'? : Sql dba

1018

how to do backup entire database? : Transact sql

1134

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1182

What is a join?

1054

Is postgresql a server?

1044

What is sql clause?

1042

What is the difference between microsoft access and sql server?

1048

What are the advantages of pl sql over sql?

1021

Is keyword pl sql?

978