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 do sql databases work?

1003

How do you delete duplicates in sql query using rowid?

949

What are the types of subqueries?

1055

What is materialized view. What are different methods of refresh?

1393

what is the difference between char_length and length? : Sql dba

1049

How to write a query to show the details of a student from students table whose

1000

Is postgresql a server?

1055

How does cross join work?

961

what is meant by nl2br()? : Sql dba

1046

Which command is used to call a stored procedure?

1002

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

How do you declare a variable in pl sql?

1032

What are the uses of merge?

1167

What is union and union all keyword in sql and what are their differences?

1108

What do we need to check in database testing?

1022