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 many queries can mysql handle?

1020

---

How to find second highest salary from a table?

1058

---

What is query log in mysql?

1037

---

How is mysql database stored?

1114

---

How do I restore a mysql database?

1135

---

What is mysql url?

917

---

write a query to mysql in safe mode and to change the root password

1002

---

What is mysql_pconnect?

969

---

What you can use regular expression for in mysql? Support your answer with an example?

960

---

Write a command to view mysql database table structure?

1010

---

Is there a free version of mysql?

987

---

How do you create a new database in mysql?

970

---

What is trigger in mysql with example?

969

---

Is pdo faster than mysqli?

946

---

can you tell the order of sql select statement? : Mysql dba

952

---