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 does the base_object_type column shows in the user.triggers data dictionary view?

994

Write a sql query to get the third highest salary of an employee from employee_table?

1026

How can you load multi line records? : aql loader

1019

Can we rollback truncate?

941

How do I remove all records from a table?

1023

What are the two characteristics of a primary key?

926

what is row? : Sql dba

1163

What is time based sql injection?

900

What is a trigger in sql?

1156

When is the explicit cursor used ?

976

What are sql commands?

933

what is unique key constraint? : Sql dba

990

What are hotfixes and patches?

882

Give the order of sql select?

1084

What is the difference between the implicit and explicit cursors?

990