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 are the two virtual tables available at the time of database trigger execution?

626

What is difference between rank () row_number () and dense_rank () in sql?

566

How do you use a while loop in pl sql?

528

what is the command line end user interface - mysql? : Sql dba

494

What is the difference between row level and statement level trigger?

508

How does one use sql*loader to load images, sound clips and documents? : aql loader

664

describe transaction-safe table types in mysql : sql dba

494

How delete a row in sql?

526

Does truncate remove indexes?

553

How delete all data from table in sql?

564

What are aggregate and scalar functions?

519

What is full join?

515

how to convert character strings to dates? : Sql dba

514

What information is needed to connect sql*plus an oracle server?

579

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

527