Interview Questions on Sql Server -Part 3
1. What are the Sql Joins? Sql Joins are the way to get data from many tables based on some…
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All? 1) Union is used to select distinct data from…
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…
Group by…..Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns. The…
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…
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a…
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It…
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following…
Third Normal Form (3NF)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy…
First Normal form (INF)
First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the…