MS SQL SERVER SOLUTION (Chapter 1 ) : Starting SQL
For
any type of query or doubt regarding any solution or if you are not
able to understand the solution or if you have any other alternative
solution that you want to show me, You can directly comment on the
corresponding class video in youtube. So that everyone can participate
in that discussion. But remember I will use the only those techniques
that we have learned so far. Exercises have been built in that way. It
does not involve any knowledge on unknown topics. When I was a student I
missed this sequential way of exercise. I tried to build the exercise
on what you have learnt recently. So that you can focus on recently
learnt topic only and a bit revise of earlier chapters. As an example,
this is the solution of chapter 1 and I have used only the techniques
learned in this chapter itself. So if you are not able to crack any logic, that
means you have to spend more time on "Basic syntax".
So
keep that in mind while commenting your doubts in the corresponding
youtube class as well. suppose you are commenting in youtube class 1,
then I will show the solutions using techniques learnt on class 1
only. Let's create a good automated way to learn this topic and create
an intelligent self learning platform by which you can get maximum
knowledge without paying anything. For the effective learning you can
copy the 1st solution code to create the dataset quickly. solution 2
onwards , you can not copy anything. you have to write it by your own
😊. Happy learning.
I am a teacher by passion not by profession. So I also want you to become passionate on databases.
For further help,
debabrataguha20@gmail.com
https://www.facebook.com/ddebb.guha/
https://www.linkedin.com/in/debabrata-guha-719008119/
------------------------------------ regarding chapter 1 ----------------------------------------
Class: https://youtu.be/zkdZTP_T4v0
You will get all the class video in youtube: https://www.youtube.com/playlist?list=PLtyCwTfL5QAzWl_mfVTjxHqGbwiyoUTnh
You will get all the exercise in the Facebook group https://www.facebook.com/groups/331231161093613/
__________________________________________________________________________
1. Q1. Create the table and insert the data.
Soln.
CREATE TABLE [dbo].[EMPLOYEE]
(
[EID] int,
[ENAME] varchar(100),
[GRADE ] varchar(1),
[AGE] int,
[GENDER] varchar(1),
[STATE] varchar(2),
[SALARY] numeric(9,2)
)
GO
INSERT INTO [dbo].[EMPLOYEE] values
(101,’Goutam Sinha’,’A’,40,’M’,’BH’,50000.00),
(102,’Srijan Basu’,’B’,30,’M’,’WB’,40000.00),
(103,’Nandini Apte’,’A’,45,’F’,’MH’,57000.00),
(104,’Satyen Murmu’,’B’,33,’M’,’JH’,32000.00),
(105,’Priya Kumari’,’C’,31,’F’,’JH’,25000.00),
(106,’Vignesh D’,’D’,25,’M’,’TN’,15000.00),
(107,’Grishma Dasari’,’C’,27,’F’,’AP’,17000.00)
Comments
Post a Comment