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
10540 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 mdb stand for?

1011

how to use case expression? : Sql dba

1031

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

Why do we create views in sql?

1155

How can you save or place your msg in a table?

1003

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016

What programs use sql?

1013

what is the difference difference between procedure and packages

10414

What is difference sql and mysql?

992

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What are system versioned tables?

1031

Can there be more than one function with a similar name in a pl/sql block?

985

Difference between global and parameter variables?

1970

Can we group by two columns in sql?

998

What is the difference between a primary key and a clustered index?

993