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
- 11529 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
Can we use ddl statements in stored procedure?
How much does sql cost?
What are the benefits of triggers?
what is query cache in mysql? : Sql dba
Explain lock escalation? : Transact sql
Is mariadb nosql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
Can we rollback truncate?
what is the use of friend function? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Explain spool.
What is sap sql anywhere?
What is the usage of when clause in trigger?
what is the difference between a local and a global temporary table? : Sql dba
