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 can I remotely connect to mysql database?

882

---

How to add a new column to an existing table in mysql?

958

---

what is cte? : Mysql dba

907

---

How do I change the max connection in mysql?

913

---

Is mysql and sql are same?

1011

---

How do I start mysql manually?

878

---

Does mysql support sequence?

899

---

What is the latest mysql version?

951

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1865

---

Is mysql a scripting language?

862

---

Describe mysql transaction properties.

975

---

How do you stop an access query?

878

---

What is mysql uuid?

896

---

What is mysql default port number?

979

---

Which is faster mongodb or mysql?

857

---