select rownum rn from (select 1 from dual group by cube(1,2,3,4,5)) where

i want to display 1 to 10 numbers using one select statement.

Question Posted / srinivas

Answer Posted / srinivas

select rownum rn from (select 1 from dual group by
cube(1,2,3,4,5)) where rownum <=10

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is foreign key in sql with example?

921

What is oracle sql called?

917

What is the starting oracle error number? What is meant by forward declaration in functions?

983

How do you get column names only for a table (sql server)?

1150

How do you update a sql procedure?

1019

How does rowid help in running a query faster?

1413

What does count (*) do in sql?

1003

What does over partition by mean in sql?

970

How to make a copy values from one column to another in sql?

1030

What is exception? What are the types of exceptions?

1066

What is a record in a database?

1056

What is the process of debugging?

1061

Why do we use cursors?

984

What is nosql db?

960

Why do we use procedures?

951