Interested to Buy Any Domain ? << Click Here >> for more details...
suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary
- 7 Answers
- 12606 Views
- I also Faced
- E-Mail Answers
Answer Posted / hemant
select * from emp where (rowid,0) in
(select rowid,mod(rownum,101) from emp)
and rownum=1
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is a sql schema used for?
What is type and rowtype in pl sql?
What is sql character function?
What is difference between hql and sql?
How long it takes to learn pl sql?
Which is better cte or subquery?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How can I tell if sql is running?
What is cte?
What is nested table in pl sql?
What is a pl/sql block?
How to create your own reports in sql developer?
Can a select statement fire a trigger?
How do you explain an index?
What is pl sql in oracle?
