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
Students
Test1
https://rextester.com/IYRZ86271
String between two indexes
SQL injection
Генерация чисел в диапазоне в MS SQL
on_thi_cuoi_ky
Solution 4
Delete double entries from a table without primary key
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...