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;

How to represent ENUMs and SETs internally?

636

---

What is database url for mysql?

444

---

What is mysql data directory? How to determine the location of the data directory?

526

---

What are date and time functions in mysql?

565

---

How to include numeric values in sql statements?

498

---

---

How do you backup a database in mysql?

577

---

Is mysql a database?

487

---

What is key in mysql?

497

---

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1665

---

What is definer in mysql trigger?

493

---

What is the role of a limit in a mysql query?

547

---

In which language mysql has been written?

865

---

Is oracle better than mysql?

465

---

How many rows we can insert in a mysql table?

486

---

How large can a mysql table be?

450

---