select * from emp where rownum<=n minus select * from emp where rownu

how u can find the n row from a table?

Question Posted / manish singhania

Answer Posted / manish singhania

select * from emp where rownum<=n
minus
select * from emp where rownum<n

n=1,2,......so many

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql pronounced sequel or sql?

1261

How can you create an empty table from an existing table?

1079

how many sql dml commands are supported by 'mysql'? : Sql dba

1122

What is the maximum database size for sql express?

1024

What is the difference between row level and statement level trigger?

1021

Which is better varchar or nvarchar?

997

What is the location of pre_defined_functions.

1166

Is sql the best database?

973

what are the drivers in mysql? : Sql dba

1021

What are the advantages of pl sql?

1122

Define overloaded procedure?

1078

Where is pl sql used?

953

What does varchar include?

948

Can a table have no primary key?

1062

How does sql profiler work?

1019