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 an escape character in sql?

557

What is the difference between clustered and non-clustered index in sql?

511

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

532

What is cascade in sql?

550

Explain the uses of control file.

605

What are the types of subqueries?

567

What is sql used for?

636

What is sorting in sql?

496

Is left join same as join?

511

What are the types of join in sql?

512

what are the security recommendations while using mysql? : Sql dba

567

Do we need to create index on primary key?

459

What are sql queries used for?

522

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

517

how to create a test table in your mysql server? : Sql dba

486