how to retrive only second row from table?

Answer Posted / sunita

select * from tab
where rownum=2;

Is This Answer Correct ?    18 Yes 142 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain foreign key in sql?

621


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

538


What are the methods of filing?

516


What are crud methods?

549


Mention what is the function that is used to transfer a pl/sql table log to a database table?

484






What is the difference between the conventional and direct path loads? : aql loader

691


Who developed sql?

567


What is sql query optimization?

541


Is it possible to include an insert statement on the same table to which the trigger is assigned?

557


What is the difference between microsoft access and sql server?

529


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

669


Can we create view in stored procedure?

522


Why is %isopen always false for an implicit cursor?

568


how to rename an existing column in a table? : Sql dba

509


What is data types in sql?

533