Answer Posted / saraswathi muthuraman

The previous post is to find the 3rd highest value.

Please find the below qry to find the top 3 highest salary

SQL> select a.EMP_NO,a.SAL,a.DEP_NO from emp_test a, (select
SAL,rank() over(order by sal desc) as rank_val from emp_test
group by sal)b where
2 a.sal=b.sal and b.rank_val <=3;

1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11

4 rows selected.

How to check server status with 'mysqladmin'?

1168

---

How to delete a database from mysql server.

1065

---

What are the 3 main types of search queries?

837

---

Is mysqli faster than mysql?

927

---

Is mysql running ubuntu?

983

---

Write a query to find duplicate rows in table?

906

---

How to set the time zone for MySQL to particular country time?

3199

---

What is the maximum size of mysql database?

953

---

how can you test for null values in a database? : Mysql dba

936

---

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1078

---

Does mysql case matter?

904

---

How do I view mysql logs?

886

---

What is mysql in linux?

1039

---

What is tee command in mysql?

950

---

Where is the mysql database stored?

910

---