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

how to find 5th row ?

Question Posted / anil

Answer Posted / anil

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can you see all indexes defined for a table? : Sql dba

995

What is trigger in sql?

1099

Does view store data in sql?

964

What are character functions?

1087

Is id a reserved word in sql?

1145

How do I view a sql database?

1021

what are the authentication modes in sql server? : Sql dba

1063

Can you join a table to itself?

1132

What is the use of sql trace?

952

what is a stored procedure? : Sql dba

1132

Does sql full backup truncate logs?

1015

Can we connect to postgresql using sql developer?

1004

Can triggers stop a dml statement from executing on a table?

1096

How to handle bulk data?

1310

What is server name sql?

1144