select * from ( select rownum rn, job_ticket_mst.* from job_ticket

how to retrive only second row from table?

Question Posted / amit kumar (patna)

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

Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures?

953

How do you declare a user-defined exception?

965

How can I make sql query run faster?

963

How can I delete duplicate rows?

966

What is a variable in sql?

953

What is procedure explain with example?

896

What are the popular database management systems in the it industry?

929

What is %type in sql?

919

What's the procedure?

867

What are different types of queries in sql?

1049

Can we alter stored procedure?

945

What are stored procedures used for?

962

Can we use ddl commands in pl sql?

1075

What are the parts of a basic sql query?

920

What are the different datatypes available in PL/SQL?

1029