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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shailesh
select 1 as "1", decode(mod(level,3), 0, 3, mod(level,3))as l,
case
when level<=3 then 1
when level>3 and level <7 then 2
else
3
end as r
from dual connect by level<10;
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
what is isam? : Sql dba
How do you optimize a query?
How is data stored in sql?
What are the two characteristics of a primary key?
How do I view a sql trace file?
Is ms sql is free?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
Is a secondary key the same as a foreign key?
What is the difference between sql and isql*plus?
What is update query?
How does a self join work?
Can a view be mutating? If yes, then how?