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
- 12711 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 difference between hql and native sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How exception handling is done in advance pl/sql?
What packages(if any) has oracle provided for use by developers?
What are triggers and its types?
What is range partitioning?
what is self join and what is the requirement of self join? : Sql dba
how can we submit a form without a submit button? : Sql dba
how many ways to get the current time? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is difference between cursor and trigger?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What does the argument [or replace] do?
What are the types of sql commands?
List different type of expressions with the example.
