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 normalization sql?

513

Is hadoop a nosql?

573

What is the difference between distinct and unique in sql?

474

What is an index in sql with example?

516

what is meant by nl2br()? : Sql dba

565

What is inner join in sql?

584

List the ways to get the count of records in a table?

508

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

553

How do you exit in sql?

589

What do you understand by pl/sql records?

534

Is id a reserved word in sql?

659

How to check if a column is nullable before setting to nullable?

582

What is the purpose of a secondary key?

506

What is cross join sql?

499

How does an execution block start and end in pl sql?

499