Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
My notes
-- ///////////SCHEMA/////////////////////////////////////////////////// CREATE TABLE Animals ([animal] varchar(5), [legs] int, [colour] varchar(6)) ; INSERT INTO Animals ([animal], [legs], [colour]) VALUES ('cat', 4, 'red'), ('bird', 2, 'yellow'), ('dog', 4, 'red'), ('deer', 4, 'red'), ('fish', 0, 'blue'), ('dingo', 4, 'yellow') ; -- //////////////////////////////////////////////////////////////////// DECLARE @applicationId INT SET @applicationId = 0 insert into animals select animal, legs, 'red' from animals where legs = 4 EXCEPT select animal, legs, colour from animals where legs = 4 select * from animals
run
|
edit
|
history
|
help
0
Practice
a
Q2_60min
MSQL in 10 mn ~ Lesson 9 Performing Mathematical Calculations - orderitems ~ expanded_price
TSQL - Logic driven by two most recent rows
Branch
BC160401693
repert
heyy
Trabalho.Agrecação