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…
Database Normalization
Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table…
Indexes in Sql server
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval…