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

How long will it take to learn pl sql?

921

What is the size of partition table?

1024

What is primary key and foreign key?

946

How do I kill a query in postgresql?

1071

What is the process of copying data from table a to table b?

1077

How do I truncate a sql log file?

1053

What is a mutating table and a constraining table?

1087

Can you sum a count in sql?

985

How do you declare a variable in pl sql?

1007

what is table? : Sql dba

1040

What do you understand by pl/sql cursors?

1070

what is oltp (online transaction processing)? : Sql dba

1063

What is pivot in sql?

900

Why join is faster than subquery?

1091

What is lexical units in pl sql?

1118