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
Can you load data into multiple tables at once? : aql loader
What is a natural join?
What is the difference between sql and mysql?
how to calculate the difference between two dates? : Sql dba
Why is normalization important?
What is sql stand for?
What is row_number () in sql?
How many columns should be in an index?
How much ram can sql express use?
what is not null constraint? : Sql dba
What is right join sql?
Show the two pl/sql cursor exceptions.
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
How many types of cursors supported in pl/sql?
Is a secondary key the same as a foreign key?