Answer / sudhakar

SELECT Salary
FROM (Table name)
WHERE Job = 'MANAGER';

Answer / 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;

What is mysql default database?

1 Answers  

---

How do I run mysql without installing?

1 Answers  

---

What is max connections in mysql?

1 Answers  

---

What is datatype in mysql?

1 Answers  

---

What is MySQL Stored Procedure?

1 Answers  

---

How do I update a variable in mysql?

1 Answers  

---

What is limit in mysql?

1 Answers  

---

What is truncate command?

1 Answers  

---

What is difference between mysql and mysqli?

1 Answers  

---

In mysql, what is joins? Explain

1 Answers  

---

How to write after insert event update trigger on the same table in mysql?

1 Answers  

---

What is the use of concat() in mysql?

1 Answers  

---