how to find 5th row ?

Answer Posted / sunil bisht

Hi Shajin
above answere is perfectly correct.
but i have one more method..


select * from emp where rownum<6 minus select * from emp
where rownum<=4;

Is This Answer Correct ?    22 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl sql commands?

555


What is indexing in sql and its types?

539


What is pessimistic concurrency control? : Transact sql

584


Why is there a need for sqlcode and sqlerrm variables?

585


How do you explain an index?

786






what is a unique key ? : Sql dba

539


Which query operators in sql is used for pattern matching?

540


What is recursive join in sql?

544


What are instead of triggers?

620


What is pl sql block structure?

538


What is an exception in pl/sql?

543


Show how functions and procedures are called in a pl/sql block.

586


What is the difference among union, minus and intersect?

544


Explain select statements in sql?

584


What is a behavioral trigger?

513