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
What is a unique key and primary key and foreign key?
What are different joins used in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are the advantages of sql?
Can you inner join the same table?
Where is all the data on the internet stored?
What are the sql versions?
What is assignment operator in pl sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
How do you rename a table in sql?
What is sorting in sql?
What is output spooling in sql*plus?
Can we group by two columns in sql?
Can you have a foreign key without a primary key?
Do we need to rebuild index after truncate?