In this study list, you will find basic to most puzzled interview queries questions with an example. This article is very useful for those who are preparing for an interview in IT company. Whether you are experienced or fresher, this study list will cover all Microsoft SQL server interview questions from basic to advanced level.
So, before starting let’s create and populate tblstudent and tblScholarship table using following script.

Create table tblStudent(    StudentId int,    FirstName varchar(50),    LastName varchar(50),    Admission_fee int,    Admission_date datetime,    Branch varchar(50),)

Create table tblScholarship(    Student_ref_id int,    Scholarship_Date date,    Scholarship_Amount int)