Answer Posted / divyasrajesh

SQL> select m.ename,m.sal from emp e,emp m where e.mgr=m.empno
2 group by m.ename,m.sal;

ENAME SAL
---------- ----------
JONES 2975
SCOTT 3000
KING 5000
BLAKE 2850
CLARK 2450
FORD 3000

6 rows selected.

This is the query for getting the managers sal from emp pls check it out dudes;

Can't connect mysql server on localhost?

1003

---

How to get help information from the server?

986

---

How do I check mysql version?

959

---

how to display nth highest salary from a table in a mysql query? : Mysql dba

1002

---

using primary can we relate two table, with out foreign key?

2660

---

What is a query in mysql?

926

---

How do I completely remove mysql from windows?

916

---

Explain the difference between procedure and function in mysql?

936

---

How to return query output in xml format?

983

---

What language is mysql written in?

929

---

How to create a trigger in mysql?

891

---

What is a join in mysql?

849

---

What is delimiter $$?

915

---

Explain % and _ inside like statement?

954

---

What is the datatype of image?

899

---