Answer Posted / saraswathi muthuraman

SQL> desc emp_test;

Name
-----
EMP_NO SAL
DEP_NO

SQL> select * from emp_test;

1001 10000 11
1001 10000 11
1002 100 11
1003 20010 11
1004 99 11
1005 50 11
1006 25 11

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;

1002 100 11

1 row selected.

How to delete a table.

911

---

How to use rank function in mysql?

962

---

What are programming functions?

930

---

What is mysql data directory?

976

---

How can I create database in mysql?

900

---

What is mvcc in mysql?

976

---

What is the role of a limit in a mysql query?

993

---

What is triggers?

946

---

What is delimiter $$?

951

---

Is mysql port 3306 tcp or udp?

903

---

How do I quit mysql?

915

---

How do I set user privileges in mysql?

873

---

Is mysql frontend or backend?

886

---

How can an index be declared in mysql?

925

---

Write a command to list all databases in mysql?

1021

---