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

Who developed sql?

1021

How to get help at the sql prompt?

1103

what are the differences between char and nchar? : Sql dba

1098

What is java sql connection?

1034

how mysql optimizes distinct? : Sql dba

1059

What does count (*) mean?

912

What is function and procedure in pl sql?

1029

How to select unique records from a table?

1041

what is sql server agent? : Sql dba

1087

What is sql dialect?

1100

Does sql full backup truncate logs?

1010

What is a ddl command?

1070

what is acid property in database? : Sql dba

1012

What are sql ddl commands?

1075

Why we use joins in sql?

968