what is the querry for all managers salary?
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 |
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is the command line end user interface - mysql?
Is mysql free download?
What is use of mysql?
What are the types of index?
What are date and time functions in mysql?
What is root password?
What are mysql data types?
What is 'mysqlshow'?
How to drop an existing table in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
How to Change a users password from unix shell.
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)