Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL_RankingFunctions
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table Employee(ID int identity(1,1) primary key, FirstName varchar(200), LastName varchar(200), Gender varchar(8), Salary int) insert into Employee(FirstName, LastName, Gender, Salary)values ('Rakesh', 'sharma', 'Male', 12000), ('Rakesh', 'Goel', 'Male', 24000), ('Vinod', 'sharma', 'Male', 35000), ('Rajni', 'sharma', 'Male', 52000), ('Renuka', 'Goel', 'Male', 24000), ('Vishakha', 'sharma', 'Male', 35000) select * from Employee
run
|
edit
|
history
|
help
0
SS my sql server 2014 4/7
Insert multiple parent-child records
wall
Running Total
SQL5
DETAILS
2021-03-06_LeetCodeSQL
bc160402152
StackOverflow_53575163
c12part2