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 show all records starting with the letters 'sonia' and the phone number '9876543210'

984

---

Is mysql from oracle?

1013

---

How can you add and remove any column of a table?

987

---

What does mysqli_fetch_assoc do?

964

---

How to use 'mysql' to run sql statements?

1167

---

What is innodb_buffer_pool_size?

1036

---

What does "i_am_a_dummy flag" do in mysql?

994

---

How many entries can mysql handle?

1058

---

Which is better mysql or microsoft sql?

976

---

What is procedure in mysql?

980

---

How can we encrypt and decrypt a data presented in a table using mysql?

1138

---

What data type is money?

906

---

In which year mysql created?

1012

---

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

1019

---

How do I quit mysql?

986

---