Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
archu
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table part (partNumber int primary key, partDescribtion varchar(50)) insert into part values(1000,'asd') insert into part values(1100,'fundmental of IT') insert into part values(200,'information technology') insert into part values(3200,'.net framework') insert into part values(1500,'routing') insert into part values(300,'interface') insert into part values(4500,'software testing') insert into part values(800,'reverse engineering') insert into part values(900,'methods in c#') insert into part values(2000,'context free grammar') insert into part values(3000,'multiplexing') insert into part values(3500,'operating system') insert into part values(400,'swing') insert into part values(4400,'operators') insert into part values(5000,'asp.net') select * from part
run
|
edit
|
history
|
help
0
TO find max marks of students
Check Constraints
ankit
Rextester.java
Chris
Cine Latinoamericano
db3
Генерация чисел в диапазоне в MS SQL
Q2_5MIN
correlated subquery & top & view & derived table & group by