how to retrive only second row from table?

Answer Posted / monika

SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL)
rn FROM emp a)
WHERE rn=2

Is This Answer Correct ?    18 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a table in a database?

553


Can we rollback truncate?

518


What is difference between joins and union?

502


Is progress software supports to ( pl/sql )?

496


What type of database is sql?

592






Why does sql need a server?

541


How many sql core licenses do I need?

485


Why do we need a foreign key?

523


Is sql injection illegal?

570


What is the limitation on the block size of pl/sql?

492


What are local and global variables and their differences?

564


What is sql resultset?

505


Which is faster view or stored procedure?

480


What is benefit of creating memory optimized table?

513


what are sequences

1066