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.

What are the non-standard sql commands supported by 'mysql'?

920

---

Why MySQL is used?

966

---

What is a mysql server?

926

---

What is mysqladmin flush hosts?

907

---

How to create trigger in mysql workbench?

933

---

What are mysql functions?

887

---

How do I change global variables in mysql?

851

---

Is there a free mysql?

834

---

How do I select a table in mysql?

859

---

How to include character strings in sql statements?

911

---

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

931

---

How do I start and stop mysql on windows?

936

---

Explain the different types of mysql joins.

851

---

How do I clear the command in mysql?

890

---

What does mysql flush hosts do?

834

---