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

What is the largest value that can be stored in a byte data field?

1021

Can unique keys be null?

918

What are the types of records?

999

Explain sql data types?

1107

What will you get by the cursor attribute sql%found?

971

How to find 3rd highest salary of an employee from the employee table in sql?

1083

What is not equal in sql?

1135

What is asqueryable?

984

Why we use joins in sql?

987

Which is better varchar or nvarchar?

1004

what is a constraint? Tell me about its various levels. : Sql dba

997

Is truncate ddl or dml?

997

how can we find the number of rows in a table using mysql? : Sql dba

1092

what tools available for managing mysql server? : Sql dba

1090

what is union? : Sql dba

1033