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

explain mysql aggregate functions. : Sql dba

991

What is union and union all keyword in sql?

1042

What are the different types of tables in sql?

1009

What is sql engine in oracle?

991

Does truncate remove indexes?

1034

What is a sql profiler?

1028

How do you remove duplicates without using distinct in sql?

977

what are the authentication modes in sql server? How can it be changed? : Sql dba

1433

Mention what does the hierarchical profiler does?

1090

Does access use sql?

1045

What is sql lookup?

920

What is a temp table?

1026

What is sqlerrd?

968

What is case function?

1042

Which sql statement is used to return only different values?

1003