Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
program2
--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 partDescribtion from part where partNumber in(1000,2000)
run
|
edit
|
history
|
help
0
Greatest_N_Per_Group
dbms pracs
Delete double entries from a table without primary key
BRYAN_BD
Manish_Sql_updated
Remove duplicates with in 10 min
Delete cascade
SQL ASSESSMENT
SALESPEOPLE
Where clause inside sub query