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 are the advantages of indexing?

992

What are different types of statements supported by sql?

1172

What does the argument [or replace] do?

1095

what are the advantages of sql ? : Sql dba

1068

What do you mean by rowid?

987

What is the usage of sql functions?

1152

Is time a data type in sql?

915

What is union?

1178

What is composite data type in pl sql?

1123

Name the operator which is used in the query for pattern matching?

967

What are the built in functions of sql?

1038

How do I know if I have sql express or standard?

1043

how to see the create table statement of an existing table? : Sql dba

1026

How many types of functions are there in sql?

959

how can we optimize or increase the speed of a mysql select query? : Sql dba

956