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
- 11530 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
Here It is asked for 101 row. It does not mean ascending or
descending order.
So query goes like this
Ans:select * from emp where rowid in(
select max(no) from
(select rowid as no,sal from emp where rownum<102));
To Find the 101th row higest salary
Ans:
select max(sal) from (
select * from emp order by sal) s where rownum<102;
similarly for 4th highest it is 5 and for (n-1)th sal it is
n.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are all the different normalization?
how to increment dates by 1 in mysql? : Sql dba
how is myisam table stored? : Sql dba
How many sql statements are used?
What is difference between sql and excel?
what are date and time intervals? : Sql dba
Which constraints we can use while creating database in sql?
How show all rows in sql?
difference between anonymous blocks and sub-programs.
What are the different types of tables in sql?
What does count (*) mean?
What can you do with pl sql?
How to get unique records from a table?
Does sqlite need a server?
Is a view faster than a stored procedure?
