Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Depending on the employee that has the following columns :Empno number(4) ,emp_name varchar2(20), salary number(5,2).job varchar2(10). To list employee names job and yearly salary

 

Depending on the employee that has the following columns :Empno number(4) ,emp_name varchar2(20), salary number(5,2).job varchar2(10). To list employee names job and yearly salary for all employees: a. Yearly salary Is not a column in table ,can not use select. O b. SELECT emp_namejob,salary*12 "yearly Salary" from EMPLOYEE c. SELECT emp_name,salary from EMPLOYEE where yearly salary=12 O d. SELECT job, salary/12 from EMPLOYEE

Step by Step Solution

3.54 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Mathematics questions

Question

If possible, solve the system. x + y + z = 2x -1 9- = = + 2y+32 = 0

Answered: 1 week ago

Question

What is attribute inheritance? Why is it important?

Answered: 1 week ago