SKLEARNING

How and why a sql inner left right full and even cross join returns the same row count We have 2 tables – TableA and TableB. Both the tables have…

How to insert data into a table that has many-to-many relationship in SQL Server We will use the following 3 tables for this example SQL Script to create the tables…

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…