select * from employees where rownum<=&nth

how u can find the n row from a table?

Question Posted / abhishekjaiswal

Answer Posted / abhishekjaiswal

select * from employees where rownum<=&nth_row
/

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is nosql db?

538

How to rename a column in the output of sql query?

533

Explain how to use transactions efficiently : transact sql

527

What is int identity in sql?

572

Is sql injection illegal?

595

explain the advantages and disadvantages of stored procedure? : Sql dba

529

what is isam? : Sql dba

572

Is it possible to create the following trigger: before or after update trigger for each row?

718

What is difference between joins and union?

529

how to dump a table to a file with 'mysqldump'? : Sql dba

549

What types of commands can be executed in sql*plus?

548

discuss about myisam index statistics collection. : Sql dba

523

How do I enable sql encryption?

518

What is a sql*loader control file?

615

Can we rollback truncate?

534