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 does select * from mean in sql?

3187

what are the advantages of sql ? : Sql dba

1043

Is merge a dml statement?

954

How to avoid duplicate records in a query?

988

explain the difference between delete , truncate and drop commands? : Sql dba

1074

Explain the commit statement.

1141

Do we need to rebuild index after truncate?

1014

What is the sql*loader? : aql loader

1039

Can you do multiple joins in sql?

1022

What is dynamic sql in pl sql?

1012

What is a record in a database?

1042

Explain the difference between sql and mysql.

1042

how to start mysql server? : Sql dba

1182

How to get list of all tables from a database?

1139

Is nosql faster than sql?

1001