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;

how do i list constraints in my database by using sql server2000?

1 Answers  

---

What is a longblob?

0 Answers  

---

What is the usage of ENUMs in MySQL?

0 Answers  

---

What is the current root password of mysql?

0 Answers  

---

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 Answers  

---

---

How to delete a database from mysql server.

0 Answers  

---

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

0 Answers  

---

How can I compare two mysql databases?

0 Answers  

---

What is foreign key in mysql?

0 Answers  

---

Why mysql is used with php?

0 Answers  

---

What is the default port number of mysql?

0 Answers  

---

Where is the mysql data directory?

0 Answers  

---