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;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where is the mysql database stored?
What is 'mysqld'?
How do I setup mysql?
What are the types of database engines available in mysql?
How to create a trigger in mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is a blob datatype?
Explain about reporting services of MYSQL?
How to load data files into tables with 'mysqlimport'?
What is longblob?
How to get last inserted id after insert data from a table in mysql?
What does mysql flush privileges do?
What is mysqli_select_db?
Explain about the architecture of MYSQL?
How to get help information from the server?