List of SQL Query questions on Top, Union, admission fees and Group by questions

List of SQL Query questions on Top, Union, admission fees and Group by questions


The following exercise will help you to improve your MS SQL server query skills effectively. I have used Microsoft SQL server 2008 R2 for the following demo

techstudy.org

Kindle Paperwhite High Resolution Display Tablet | Rs. 9999

So, before starting let's create and populate tblstudent and tblScholarship table using following script.


1
2
3
4
5
6
7
8
9
Create table tblStudent
(
	StudentId int,
	FirstName varchar(50),
	LastName varchar(50),
	Admission_fee int,
	Admission_date datetime,
	Branch varchar(50),
)

- tblstudent

StudentId FirstName LastName Admission_fee Admission_date Branch
1 John Smith 1000 2018-06-10 Computer Engineering
2 David Jones 1200 2018-06-20 Civil Engineering
3 Michael Johnson 900 2018-08-15 Chemical Engineering
4 Chris Lee 1500 2018-07-10 Electrical Engineering
5 Mike Brown 1600 2018-09-10 Mechanical Engineering
6 Lisa Smith 1800 2018-07-10 Computer Engineering
7 Mary Smith 1600 2018-06-11 Computer Engineering
     




Related Topics



Responses




Popular Posts

Facebook

Founded in 2016, Tech Study passionately delivers stylish and dynamic innovative information to programmer and technology lovers. http://www.techstudy.org/.