Similar Collections

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)

questions

Title
Show only time part of the “AdmissionDate” from tblStudent.
Select no of students get admission with respect to year and month from tblStudent table.
Select TOP Nth (any number) admission fees from tblStudent table
Select second highest admission fees from “tblStudent” table.
Select TOP 2 Admission fees from tblStudent table
Select Highest Admission fees from tblStudent table.
Select Minimum Admission fees from tblStudent table.
Select FirstName, LastName from tblStudent table in singal column.
Get students details from “tblStudent” table whose admission fees is less than 15000.
Get students details from “tblStudent” table whose admission fees is greater than 15000.
Get students details from “tblStudent” table whose admission fees in between 10000 and 15000.
Select 5 % of admission fees from sara , 10% of admission fees from Dora and for other 15 % of admission fees as ‘Deducted_Admission_fee’ from tblStudent table.
Write a query to get how many students exist in tblstudent.
Write the query to get the branch and branch wise total(sum) admission fees, display it in ascending order according to admission fees.
Write the query to get the branch and branch wise total(sum) admission fees, display it in desending order according to admission fees.
Get branch wise average admission fees from “tblStudent” table order by admission fees ascending order.
Get branch wise maximum admission fees from “tblStudent” table order by admission fees descending order.
Get branch wise minimum admission fees from “tblStudent” table order by admission fees ascending order.
Get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending.
Select no of students joined with respect to year and month from tblStudent table.
total questions: 92

Questions

92

Views

1526

Best Answers

299

Points

5