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 :- EMPEDITEMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO 7839KINGPRESIDENT-11/17/19815000-10 7698BLAKEMANAGER783905/01/19812850-30 7782CLARKMANAGER783906/09/19812450-10 7566JONESMANAGER783904/02/19812975-20 7788SCOTTANALYST756612/09/19823000-20 7902FORDANALYST756612/03/19813000-20 7369SMITHCLERK790212/17/1980800-20 7499ALLENSALESMAN769802/20/1981160030030 7521WARDSALESMAN769802/22/1981125050030 7654MARTINSALESMAN769809/28/19811250140030 7844TURNERSALESMAN769809/08/19811500030 7876ADAMSCLERK778801/12/19831100-20 7900JAMESCLERK769812/03/1981950-30 7934MILLERCLERK778201/23/19821300-10

Find the required query and output given as below :

Answered: Write a query to show all record of…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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

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

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions