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

Are null values same as that of zero or a blank space?

531

Can we update views in sql?

531

What is right join sql?

532

What is integrity in sql?

557

What is the usage of the distinct keyword?

682

Can you call pl/sql package functions from within a fast formula?

560

what are all the different types of indexes? : Sql dba

526

How do I save the results of sql query in a file?

533

What is an index in sql with example?

514

Define the select into statement.

568

Is left join same as inner join?

535

What are the basic techniques of indexing?

572

how to enter binary numbers in sql statements? : Sql dba

487

What is view? Can we update view

865

which types of join is used in sql widely? : Sql dba

537