select rownum from emp where rownum<=10;

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

Question Posted / raghuramu

Answer Posted / raghuramu

select rownum from emp
where rownum<=10;

Is This Answer Correct ?

13 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is anonymous block in sql?

1128

Is like operator in sql case sensitive?

1033

What is use of package in pl sql?

1023

What is an example of translating a date into julian format?

1129

Can two tables have same primary key?

985

explain primary keys and auto increment fields in mysql : sql dba

983

How to check if a column is nullable before setting to nullable?

1133

what are different types of keys in sql?

1163

Is sql similar to python?

984

Explain alias in sql?

1055

What is a string data type in sql?

1049

how to increment dates by 1 in mysql? : Sql dba

987

How to test for null values?

1059

Can primary key be changed?

913

What is the maximum number of columns in sql table?

1180