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 to convert character strings to dates? : Sql dba

979

What are sql queries used for?

974

Are sql database names case sensitive?

934

What is an ndf file?

925

What is the use of double ampersand (&&) in sql queries? Give an example

1076

Why plvtab is considered as the easiest way to access the pl/sql table?

1128

What is asqueryable?

902

what is 'mysqlcheck'? : Sql dba

958

How do you explain an index number?

1019

Explain what is a database?

1033

What is pragma in sql?

1018

What is substitution variable?

999

In what condition is it good to disable a trigger?

967

what is an index? : Sql dba

924

Can we create table in function?

907