how to retrive only second row from table?

Answer Posted / vamsi nukala

select * from(select rownum as rno,emp.* from emp)where rno=2;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

591


What are secondary keys?

548


What is the difference between local variables and global variables?

597


what is subquery? : Sql dba

562


what is rdbms? : Sql dba

570






How do I run a pl sql procedure in sql developer?

503


How many types of literals are available in pl sql?

503


What is an inconsistent dependency?

568


Is sql microsoft?

537


How do I sort a table in sql?

585


what are all the different normalizations? : Sql dba

500


Is sql similar to python?

527


What is sqlca in db2?

523


What is trigger point?

525


What is an intersect?

643