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

Can you load data into multiple tables at once? : aql loader

801


What is a natural join?

733


What is the difference between sql and mysql?

759


how to calculate the difference between two dates? : Sql dba

725


Why is normalization important?

749






What is sql stand for?

744


What is row_number () in sql?

730


How many columns should be in an index?

709


How much ram can sql express use?

699


what is not null constraint? : Sql dba

723


What is right join sql?

711


Show the two pl/sql cursor exceptions.

806


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

781


How many types of cursors supported in pl/sql?

794


Is a secondary key the same as a foreign key?

673