Question: This is SQL help. Use a subquery to show the information for all the employees in DEPTNO = 20 but don't show the information for

This is SQL help. Use a subquery to show the information

This is SQL help. Use a subquery to show the information for all the employees in DEPTNO = 20 but don't show the information for the employee named Ford.

SQL> selectfrom emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP -81 7839 01-MAY-81 7839 09-JUN-81 7566 19-APR-87 800 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 20 30 30 20 30 30 10 20 10 30 20 30 20 10 300 500 1400 17-NOV-81 7698 08-SEP -81 7788 23-MAY-87 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This is SQL help. Use a subquery. Show the employees that earn a higher salary than MANAGER and ANALYST. SQL> selectfrom emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH 7499 ALLEN 7521...

PS13 Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table, and uses a sub-query to show that earn more than the average salary. You will have to...

Please answer the SQL questions according to the information below thanks Use the operator and/or statement asked. Otherwise, you will have zero (0) point for the question. Your answer document MUST...

SQL statements. 1. Show employees who do not have commission. What commando to use? 2. Show today's date and time in Norwegian format. What commando to use? 3. Show employees who do not have 500 in...

Unit 5 Lab - SQL statements - Need help on these Database Below: CREATE TABLE DEMO_DEPT (DEPTNO NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY, DNAME VARCHAR2(14), LOC VARCHAR2(13) ); INSERT INTO DEMO_DEPT...

- - You are to develop SQL statements for each task listed. - - You should type your SQL statements under each task. / * Submit your . sql file named with your last name, first name and assignment #...

P 1 . Write the SQL code that will create only the table structure for a table named EMP _ 1 . This table P 7 . Using the EMP _ 2 table, write the SQL code that will add the attributes EMP _ PCT and...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

The Mountainside Corporation manufactures similar products in the United States and Norway. The U. S. and Norwegian operations are organized as decentralized divisions. The following information is...

If the government decides that aggregate demand is excessive and is causing inflation, what options are open to it? What if the government decides that aggregate demand is too weak instead?

For the current year, Patterson Company incurred $218,000 in actual manufacturing overhead cost. The Manufacturing Overhead account showed that overhead was overapplied in the amount of $16,500 for...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

2. Consider a group to which you belongyour communication class, your family, your religious community, and so on. Draw a chart that depicts members of the group and the patterns of communication...

4. Consider the adjourning phase of group development for a group you were part of that disbandedScouts, a sports team, the school newspaper staffand think about what aspects of the group made for...

4. Explain how a groups cohesion, norms, and individual differences affect group processes and outcomes