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
- 12908 Views
- I also Faced
- E-Mail Answers
Answer Posted / meher
Let the table name is EMP
To find 101st row the query is as below:
select * from EMP where rownum <= 101
minus
select * from EMP where rownum <= 100;
for Nth salary the query is as below:
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to get list of all tables from a database?
What is the need of merge statement?
What does joining a thread mean?
What is a parameter query?
How to create your own reports in sql developer?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is data type in sql?
what is index? : Sql dba
Why do we use %rowtype & %type in plsql?
what are the different index configurations a table can have? : Sql dba
What are the advantages of stored procedure?
Why do we use procedures in pl sql?
What are the triggers associated with image items?
What is not null in sql?
where are cookies actually stored on the hard disk? : Sql dba
