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 ways we can retrieve the date in result set of mysql using php?

1102

---

Tell us something about heap tables?

973

---

Is mysql a scripting language?

877

---

What are stored procedures and functions?

885

---

What does mysql flush hosts do?

872

---

What is mysql command line?

1024

---

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4649

---

What does mysqli stand for?

913

---

What is a crosstab query?

937

---

Can mysql store files?

914

---

What are features of mysql?

881

---

Write a command to list all databases in mysql?

1021

---

What are the differences between a primary key and foreign key?

1076

---

What is mysql57?

894

---

What are views in mysql?

912

---