Question
Asked Nov 12, 2019
1 views

Let's say we have the attached table :

 

Find the year in which employees hired with minimum salary more than 1000

EMP:
NUMBER (4)
EMPNO
VARCHAR2 (10)
ΕΝΑΜΕ
VARCHAR2 (9)
JOB
NUMBER (4)
MGR
HIREDATE
DATE
NUMBER (7, 2)
SAL
NUMBER (7, 2)
СOMM
NUMBER (2)
DE PTNΟ
DEPT:
NUMBER (2)
DE PTNΟ
VARCHAR2 (14)
DNAME
VARCHAR2 (13)
LOC
help_outline

Image Transcriptionclose

EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

fullscreen
check_circle

Expert Answer

Step 1

Answer:

Select HIREDATE from EMP where SAL > 1000;

Here, the above query will display the employees &...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Compare and contrast iOS and Android mobile operating systems. Which one is better?

A: Comparison of Android and iOS:

question_answer

Q: Create 10 echo statements introducing yourself, your major , your favorite color , your dream vacati...

A: The echo statement is used in PHP to print the data to the output screen.echo statement has no retur...

question_answer

Q: What are the mantissa and exponent of 6.75 in 8-bit floating point binary system?

A: The given number is 6.75First, convert it in binary form.Binary form of 6 is 110Binary form of 0.75 ...

question_answer

Q: What is the value of sum and count after the execution of the following while loop? (All variables a...

A: Value of sum and countIn the program, count = 15. In the while loop, the statement count<=15 beco...

question_answer

Q: Write a system calls your program is allowed to use: fprintf(), open(), fgets(), and fclose(). Do no...

A: System calls:A system call can be defined as a request to do something to the operating system on be...

question_answer

Q: (select all that apply) In MS Access, to ensure that a grade must be either A, B, C, D or F, whichva...

A: Validation rule:In MS Access, the validation rule used to ensure the grade that must be either A, B,...

question_answer

Q: I need help with this programming exercise:   Write a C++ console application that allows your user ...

A: Program code #1:

question_answer

Q: Double any element's value that is less than minValue. Ex: If minValue = 10, then dataPoints = {2, 1...

A: Completing the given C++ program so, that it can follow the given rubrics:The array is already decla...

question_answer

Q: Write a method named sumInts that can take a variable number of int arguments and return the sum of ...

A: Below is the approach, and a java program to display the sum of integer arguments, passed in the sum...