Skip to main content

Posts

Showing posts with the label Test your knowledge on SQL

SQL Queries from Multiple tables and Questions

Question -Employee_Details EmpID NVARCHAR(10) Emp_FirstName NVARCHAR(100) Emp_LastName NVARCHAR(100) DateOfJoining Datetime Employee_Salary EmpID NVARCHAR(10) Refers to Employee Details PayPeriodId INT Refers to Master_PayPeriod SalaryAmount Money DateofSalaryCreditedtoAccount Datetime Master_PayPeriod PayPeriodID INT PayMonthYear Datetime Employee Details Sample Data 000001 ABC XYZ 01-Jan-2000 000002 Rahul Y 13-Dec-2000 000003 Amit S 12-Apr-2000 000004 Shobit K 01-Jan-2000 000005 Harshit J 13-Dec-20