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
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 is a primary key sql?
how to get a list of columns in an existing table? : Sql dba
Why is sql better than hql?
How do I sort a table in sql?
What are some predefined exceptions in pl/sql?
Why is theta join required?
how is myisam table stored? : Sql dba
Define a temp table?
How many types of functions are there in sql?
How many rows can sqlite handle?
What is the limitation on the block size of pl/sql?
What is sql clause?
What are the types of triggers in sql?
What program will open a mdb file?
Do ddl statements need commit?