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
- 12906 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 is a primary key? : Sql dba
What are the basic sql commands?
Do we need to create index on primary key?
What is not in sql?
How do you know if a relationship is 2nf?
how many values can the set function of mysql take? : Sql dba
what is isam? : Sql dba
What are local and global variables and their differences?
Show the cursor attributes of pl/sql.
What is the difference between delete and truncate statement in sql?
What is the difference between python and sql?
what is a view? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
What are different types of queries in sql?
what are the t string functions available in tsql? : Transact sql
