Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Modern Database Management
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
12th edition
133544613, 978-0133544619
Students also viewed these Mathematics questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App