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;

Does mysql scale well?

0 Answers  

---

What is the use of mysql_close()?

0 Answers  

---

Can I use mysql for free?

0 Answers  

---

What are the different mysql database engines?

0 Answers  

---

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

0 Answers  

---

---

How do you create a table in mysql workbench?

0 Answers  

---

How large can a mysql table be?

0 Answers  

---

What is the difference between b-tree and hash indexes?

0 Answers  

---

Can you tell how to find the number of rows in a resultset using php?

0 Answers  

---

What is the date format in mysql?

0 Answers  

---

What is mysql common?

0 Answers  

---

What is maximum size of a database in MySQL?

13 Answers   Bastioncoup, CIS, NM, V2 Solutions, Wipro,

---