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 load data files into tables with 'mysqlimport'? : Sql dba

540

What are the types of optimization?

531

What is the difference between function and procedure in pl/sql?

559

What are types of joins?

547

Does group by remove duplicates?

563

Is sql dba a good career? : SQL DBA

544

Which type of cursor is used to execute the dml statement?

542

What is the reports view in oracle sql developer?

557

What is the sql*loader? : aql loader

599

The select into statement is most often used to create backup copies of tables or for archiving records?

576

What do you mean by stored procedures?

564

Is ms sql is free?

546

Does sql profiler affect performance?

568

What operators deal with null?

619

how to use myisamchk to check or repair myisam tables? : Sql dba

519