SQL SERVER

select all names that start with a given letter without like operator in Sql Server We will discuss writing a SQL query to retrieve all student names that start with…

Difference between blocking and deadlocking we will discuss the difference between blocking and deadlocking. This is one of the common SQL Server interview question. Let us understand the difference with…

Can we join two tables without primary foreign key relation in SQL Server Yes, we can join two tables without primary foreign key relation as long as the column values…

Real time example for right join in SQL Server In my opinion this is a very good sql server interview question. Question 1: Can you list different types of JOINS…

Join 3 tables in sql server Joining 3 tables (or even more) is very similar to joining 2 tables. We will be using the following 3 tables in this demo.SQL…

Difference between inner join and left join in SQL Server This is one of the very common sql server interview question. Different JOINS in SQL Server are discussed in detail…

find department with highest number of employees in SQL Server We will be using the following tables (Employees & Departments) to answer this question. In Employees table DepartmentID is the…

SQL query to find rows that contain only numerical data Let me explain the scenario mentioned in one of the sql server interview. We have the following table. Write a…

Transform rows into columns in sql server This is another common sql server interview question. We will be using the following Countries table in this example.transpose rows to columns sql…

How to find employees hired in last n months in SQL Server This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then…