KnowStar E-learning solutions

SQL Query - Employees retiring at the end of the month

SQL Query - How to identify employees retiring at the end of the month Please find below the SQL Qu…

byknowstar •February 15, 2021

SQL Query - How to find employees hired in last 'n' months | Datediff

We are going to work with Employee Data as shown below - You can create this table with the below S…

byknowstar •February 02, 2021

UNIX - Sed command to rename multiple files in a folder by replacing a substring in the file name.

Requirement - Folder has multiple .csv files starting with Knowstar. For ex - Knowstar_V1_1.csv    …

byknowstar •January 28, 2021

SQL Query - Convert data from rows into comma separated string value - FOR XML PATH and STUFF

Please watch the below YouTube video for complete explanation - https://www.youtube.com/watch?v=aDH…

byknowstar •January 28, 2021

SQL - Convert data from Columns into Rows - UNPIVOT

Please watch the below YouTube video for complete explanation. https://www.youtube.com/watch?v=mf4A…

byknowstar •January 28, 2021

SQL Interview Queries on Employee Salary Database - 6 SQL Queries

1) Employee with highest salary in the department Query 1 Select EmployeeKey, FirstName, LastName, …

byknowstar •January 28, 2021