how to retrive only second row from table?

Answer Posted / ehtesham malik

select * from emp
where rowid = (select min(rowid) from emp
where rowid not in (select min(rowid)
from emp)
)

Is This Answer Correct ?    4 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the methods of filing?

526


What do you mean by “trigger” in sql?

633


Can a varchar be a primary key?

546


What is 19 null in sql?

546


Explain alias in sql?

594






Can a primary key be a foreign key?

583


Can I call a procedure inside a function?

564


How do you create an update query?

536


What are different categories of sql commands?

646


What is not in sql?

510


What is the starting oracle error number? What is meant by forward declaration in functions?

551


What is trigger point?

552


What are the two different parts of the pl/sql packages?

576


Which command is used to call a stored procedure?

512


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

575