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

How do I add a database to sql?

1087

What are the possible values for the boolean data field?

922

Why indexing is needed?

956

What is sql basics?

1009

Explain the update statement in sql

934

How do you declare a user-defined exception?

975

Is a secondary key the same as a foreign key?

979

Mention what are the benefits of pl/sql packages?

1023

what are the types of join and explain each? : Sql dba

1009

what is collation? : Sql dba

1103

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1091

Can sql function call stored procedure?

966

how do you tune the slow running queries in oracle db , explain the methodology

2288

explain normalization concept? : Sql dba

1011

What is meant by temporal data?

924