Use These Two Tables To Write Sql Statements For The Following Dept Deptno Dname Loc 10 Accounting New York 20 Research 1 (98.48 KiB) Viewed 17 times
Use These Two Tables To Write Sql Statements For The Following Dept Deptno Dname Loc 10 Accounting New York 20 Research 2 (21.47 KiB) Viewed 17 times
USE THESE TWO TABLES TO WRITE SQL STATEMENTS FOR THE FOLLOWING: DEPT DEPTNO DNAME LOC 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO EMP EMPNOENAME JOB MGRHIREDATESAL DEPTNO 7369 SMITH CLERK 7902/17-DEC-80 800 20 7499 ALLEN SALESMAN769820-FEB-81160030 7654 MARTIN SALESMAN769828-SEP-81 125030 7698 BLAKE MANAGER 783901-MAY- 285030 81 7782 CLARK MANAGER 783909-JUN-81 245010 7788 SCOTT ANALYST 756619-APR-87300020 3.1. Display all information in the table EMP. (2) 3.2. Display all information in the table DEPT. 121
3.3. Display the names and salaries of all employees with a salary less than 1000. (2) 3.4. Display the names and hire dates of all employees. (3) 3.5. Display the department number and
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!