MS SQL Update Select Top

CREATE TABLE StudentMast (
StudentId INT
, StudentName VARCHAR(250)
)

CREATE TABLE ClassMast (
ClassId INT
, ClassName VARCHAR(100)
)

CREATE TABLE Results (
StudentId INT
, ClassId INT
, RollNo INT
, Lang1 INT
, Lang2 INT
, Lang3 INT
, Sub1 INT
, Sub2 INT
, Sub3 INT
, TotalMarks INT
, Average INT
, Result CHAR(4)
, Division CHAR(10)
)



Insert Into ClassMast (ClassId, ClassName)
Values
(1, '1st'),
(2, '2nd'),
(3, '3rd'),
(4, '4th'),
(5, '5th'),
(6, '6th'),
(7, '7th'),
(8, '8th'),
(9, '9th'),
(10, '10th')

select * from ClassMast

Insert Into StudentMast (StudentId, StudentName)
Values
(1,'Raj'),
(2,'Ravi'),
(3,'Ram'),
(4,'Rakesh'),
(5,'Raghu'),
(6,'Amit'),
(7,'Ajay'),
(8,'Amar'),
(9,'Mahesh'),
(10,'Shankar')

select * from StudentMast


Insert Into Results(StudentId,ClassId,RollNo,Lang1,Lang2,Lang3,Sub1,Sub2,Sub3,TotalMarks,Average,Result,Division)
Values
(1, 9, 1,54,98, 91, 54, 78, 48, 423,70.50, 'PASS','1ST CLASS'),
(2,9, 2,25 ,75 ,35 ,88 ,95 ,54 ,372 ,62.00 ,'FAIL', 'FAIL'),
(3,9, 3,45 ,65 ,48 ,78 ,45 ,85 ,366 ,61.00 ,'PASS', '1ST CLASS'),
(4,9, 4,95 ,65 ,68 ,96 ,78 ,77 ,479 ,79.83 ,'PASS', '1ST CLASS'),
(5,9, 5,75 ,77 ,92 ,35 ,35 ,48 ,362 ,60.33 ,'PASS', '1ST CLASS'),
(6,9, 6,45 ,85 ,75 ,49 ,45 ,65 ,364 ,60.67 ,'PASS', '1ST CLASS'),
(7,9, 7,25 ,98 ,19 ,85 ,45 ,32 ,304 ,50.67 ,'FAIL', 'FAIL'),
(8,9, 8,95 ,65 ,95 ,45 ,88 ,45 ,433 ,72.17 ,'PASS', '1ST CLASS'),
(9,9, 9,87 ,45 ,74 ,95 ,97 ,95 ,493 ,82.17 ,'PASS', '1ST CLASS'),
(10,9,10,54 ,58 ,92 ,25 ,54 ,94 ,377 ,62.83 ,'FAIL', 'FAIL')


select * from Results

select count(0) from Salaries

select top 100 * from Salaries

select top 100 * from Results

select count(*) from Results

select count(1) from Results

select top 10 BasicSalary,HRA,DA, BasicSalary + HRA + DA from Salaries


select 3214.21 + 1569.10 + 2741.47

select StudentName, StudentId from StudentMast

select StudentId from StudentMast

select Division, Result From Results

select top 10 * from Salaries

Update Salaries set Earnings = BasicSalary + HRA + DA
Update Salaries set Deductions = IT + PF
Update Salaries set NetSalary = Earnings - Deductions