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 do I start sql from command line?

1081

Is like operator in sql case sensitive?

1077

what is 'mysqlimport'? : Sql dba

1109

Does db2 use sql?

1009

What is mdf ldf and ndf?

1057

What are all the different normalization?

1079

what is unique key constraint? : Sql dba

1096

What is the cause of mutating table error and how can we solve it?

1097

Can you have more than one trigger on a table?

1046

How can check sql version from command line?

1135

What is sql profiling in oracle?

1128

What is sql injection owasp?

1113

What are sql commands?

1067

How many disk partitions should I have?

1040

What are some emotional triggers?

1033