Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Which one of the following queries will fetch Employee FullName and its Salary? Refer table below. 1 SELECT e.FullName, s. Salary FROM Employee Details e
Which one of the following queries will fetch Employee FullName and its Salary? Refer table below. 1 SELECT e.FullName, s. Salary FROM Employee Details e INNER JOL EmployeeSalary s ON e. EmpId = s. Salary: Table - EmployeeDetails Table - EmployeeSalary 1 SELECT e. FullName, s. Salary FROM EmployeeDetails e INNER JOI EmployeeSalary s ON e. Salary = s. Salary: Empid FullName ManagerId DateOfJoining EmpId Project Salary O 121 John Snow 321 1 SELECT e.FullName, s. Salary FROM Employee Details e INNER JOIH EmployeeSalary s ON e. EmpId = s. EmpId; 01/31/2014 121 P1 8000 321 Walter White 986 01/30/2015 321 P2 1000 1 SELECT e.FullName, s. Salary FROM EmployeeDetails e INNER JOIN EmployeeSalary s ON s. EmpId = s. Emp Id; 421 Kuldeep Rana 876 27/11/2016 421 P1 12000
Step by Step Solution
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 Started