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

Can sql function call stored procedure?

566


What is sql scripting?

571


What is sql and how does it work?

557


What is %s in sql?

576


How many times can we commit in a loop?

578






How do you optimize a query?

545


What is the size of partition table?

569


Does sql*plus also have a pl/sql engine?

567


Can you inner join the same table?

536


What does truncate mean in sql?

544


What is crud sql?

559


Why indexing is needed?

528


Can ddl statements be used in pl/sql?

602


What is trigger and types?

578


What is sql keyword?

576