I need to create SQL coding for Oracle databases 1.list the employee number posi

Question

I need to create SQL coding for Oracle databases
1.list the employee number position and salary of an employee who is an Analyst programmer?
2.name the employee number who joined on the 10-mar-68 or has a salary of more than 20000 but the designation is Assistent account manager? I need to create SQL coding for Oracle databases
1.list the employee number position and salary of an employee who is an Analyst programmer?
2.name the employee number who joined on the 10-mar-68 or has a salary of more than 20000 but the designation is Assistent account manager?
1.list the employee number position and salary of an employee who is an Analyst programmer?
2.name the employee number who joined on the 10-mar-68 or has a salary of more than 20000 but the designation is Assistent account manager?

Explanation / Answer

A) Select Emp_id. , Salary , Position

FROM Employee WHERE Emp_position= Analyst Programmer

B) Select Empno. , Position ,Startdate ,Salary

        FROM Emp_jobhistory

WHERE (Startdate <10-march-68>

AND Salary>=20000

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.