how to retrive only second row from table?

Answer Posted / amit kumar (patna)

select * from
( select rownum rn, job_ticket_mst.* from job_ticket_mst where rownum<=2)
where rn=2

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does where 1 1 mean in sql?

527


Does varchar need length?

506


How to start the command-line sql*plus?

551


How do you create a db file?

510


What is delete command in sql?

541






What are the uses of merge?

708


Why do we use procedures in sql?

540


Does truncate free space?

508


What is the difference between a procedure and a function?

480


What is where clause in sql?

517


How many disk partitions should I have?

536


Is big data nosql?

503


What is rename in sql?

542


Which is better join or subquery?

596


What is pl/sql table? Why it is used?

547