Interested to Buy Any Domain ? << Click Here >> for more details...
what is the querry for all managers salary?
- 2 Answers
- 4330 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudhakar
SELECT Salary
FROM (Table name)
WHERE Job = 'MANAGER';
| Is This Answer Correct ? | 10 Yes | 2 No |
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;
| Is This Answer Correct ? | 3 Yes | 0 No |
Why mongodb is faster than mysql?
What is the difference between a heap table and temporary table?
What are mysql functions?
What's the difference between mysql and sql server?
Is mysql server free?
What is the difference between is null & is not null?
How to increment dates by 1 in mysql?
How do you select a table?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Is pdo more secure than mysqli?
Is mysql connect deprecated?
change column name and make a unique column so we get no dupes.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
