Interview Questions on sql server -Part-1

1. What is the Normalization? Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables and defining relationship between them so that deletion, updation and insertion can be made […]

Continue Reading

Difference Between Having and Where Clause in Sql Server

Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there are some differences between them. These difference are given below:- To show the difference between the Where Clause and the Having clause we will going to use the table EmployeeDeptInfo whose create query statement  is […]

Continue Reading