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

how to show all tables with 'mysql'? : Sql dba

818

What is an exception in PL/SQL? What are the two types of exceptions?

851

What operators deal with null?

813

What is a table in a database?

786

What do you mean by table in sql?

696

What are the benefits of triggers?

898

What is parameter substitution in sql?

755

Does oracle roll back the transaction on an error?

745

What is serial sql?

701

Can you rollback after commit?

718

What are the usages of sql?

752

Name three sql operations that perform a sort.

789

How do I remove sql plus from windows 10?

765

How sql query is executed?

782

what is the difference between join and union? : Sql dba

720