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
What is a table in a database?
Can we rollback truncate?
What is difference between joins and union?
Is progress software supports to ( pl/sql )?
What type of database is sql?
Why does sql need a server?
How many sql core licenses do I need?
Why do we need a foreign key?
Is sql injection illegal?
What is the limitation on the block size of pl/sql?
What are local and global variables and their differences?
What is sql resultset?
Which is faster view or stored procedure?
What is benefit of creating memory optimized table?
what are sequences