Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write a query to show all record of job-history of those employees whose department number 60? SELECT first_name from employees where first_name like ‘S%’; SELECT first_name from employees where first_name like ‘_e%’; table Name :- EMP EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO   7839 KING PRESIDENT - 11/17/1981 5000 - 10   7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30   7782 CLARK MANAGER 7839 06/09/1981 2450 - 10   7566 JONES MANAGER 7839 04/02/1981 2975 - 20   7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20   7902 FORD ANALYST 7566 12/03/1981 3000 - 20   7369 SMITH CLERK 7902 12/17/1980 800 - 20   7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30   7521 WARD SALESMAN 7698 02/22/1981 1250 500 30   7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30   7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30   7876 ADAMS CLERK 7788 01/12/1983 1100 - 20   7900 JAMES CLERK 7698 12/03/1981 950 - 30   7934 MILLER CLERK 7782 01/23/1982 1300 - 10

Write a query to show all record of job-history of those employees whose department number 60? SELECT first_name from employees where first_name like ‘S%’; SELECT first_name from employees where first_name like ‘_e%’; table Name :- EMP EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO   7839 KING PRESIDENT - 11/17/1981 5000 - 10   7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30   7782 CLARK MANAGER 7839 06/09/1981 2450 - 10   7566 JONES MANAGER 7839 04/02/1981 2975 - 20   7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20   7902 FORD ANALYST 7566 12/03/1981 3000 - 20   7369 SMITH CLERK 7902 12/17/1980 800 - 20   7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30   7521 WARD SALESMAN 7698 02/22/1981 1250 500 30   7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30   7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30   7876 ADAMS CLERK 7788 01/12/1983 1100 - 20   7900 JAMES CLERK 7698 12/03/1981 950 - 30   7934 MILLER CLERK 7782 01/23/1982 1300 - 10

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 52P
See similar textbooks
icon
Related questions
Question
  • Write a query to show all record of job-history of those employees whose department number 60?
  • SELECT first_name from employees where first_name like ‘S%’;
  • SELECT first_name from employees where first_name like ‘_e%’;

table Name :- EMP

EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
  7839 KING PRESIDENT - 11/17/1981 5000 - 10
  7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30
  7782 CLARK MANAGER 7839 06/09/1981 2450 - 10
  7566 JONES MANAGER 7839 04/02/1981 2975 - 20
  7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20
  7902 FORD ANALYST 7566 12/03/1981 3000 - 20
  7369 SMITH CLERK 7902 12/17/1980 800 - 20
  7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30
  7521 WARD SALESMAN 7698 02/22/1981 1250 500 30
  7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30
  7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30
  7876 ADAMS CLERK 7788 01/12/1983 1100 - 20
  7900 JAMES CLERK 7698 12/03/1981 950 - 30
  7934 MILLER CLERK 7782 01/23/1982 1300 - 10
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS