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;

Where is the mysql database stored?

917

---

What is 'mysqld'?

951

---

How do I setup mysql?

907

---

What are the types of database engines available in mysql?

1043

---

How to create a trigger in mysql?

941

---

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1101

---

What is a blob datatype?

868

---

Explain about reporting services of MYSQL?

1074

---

How to load data files into tables with 'mysqlimport'?

1001

---

What is longblob?

989

---

How to get last inserted id after insert data from a table in mysql?

985

---

What does mysql flush privileges do?

935

---

What is mysqli_select_db?

973

---

Explain about the architecture of MYSQL?

982

---

How to get help information from the server?

1056

---