Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Teacher
Create table teacher (teacherid int,name varchar(20),subject char(20),class varchar(20) Primary key (teacherid)); Insert into teacher (teacherid ,name,subject,class) values(234,'abb','computer','bsc comp sci'); Insert into teacher (teacherid ,name,subject,class) values(244,'hjkb','maths','bsc comp sci'); Insert into teacher (teacherid ,name,subject,class) values(255,'kkll','physics','bsc nm'); Insert into teacher (teacherid ,name,subject,class) values(266,'ggh','chemistry','bsc nm'); Insert into teacher (teacherid ,name,subject,class) values(277,'fgh','maths','B.A'); Select * from teacher;
run
|
edit
|
history
|
help
0
Adding, subtracting, rounding and calculating differences
Chris
DGDFGDFG
12
Sum then delete one row - SQL Server 2008 R2
List longest unique string for each id
Conditional Operator (IIF)
llaves vistas (alumnos) Karen
Merge Sample Code
jueves