Introduction:  This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue: Business wants a report that [...]

Introduction:  This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name etc ..   Cause of the issue: [...]

Introduction:   This SQL query is used to fetching the data of Employees Work Schedule changes like Work Schedule id, Name etc…  In this Last update date is used as a parameter so based on the [...]

Introduction:   This SQL query is used to fetching the data of Employees Assignment changes like Manager change, location change etc… In this Last update date is used as a parameter so [...]

Introduction: This SQL query is used to fetching the data for Employees who are Revoked means cancelled the termination those employees will fetch based on last update date.   SQL Query: [...]

Introduction: This SQL query is used to fetching the data for candidates who are applied various assessment tests (Wheebox)  at the time of recruiting like one candidate can apply two or more [...]

Introduction: This SQL query is used to fetching the data for candidates who are attended various assessment tests at the time of recruiting. In this assessment name is used as a parameter, based [...]