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
CTE reqursive query
OUTPUT CLUASE
sql-server-storing-wildcards-in-data
emp
Service broker
Dividing runs by time stamp
member
TSQL - Logic driven by two most recent rows
bc160401693
dbms