Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Segundo
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE products ( id NUMERIC, name VARCHAR(255), amount NUMERIC, price NUMERIC ) INSERT INTO products ( id, name, amount, price ) VALUES ( 1, 'Two-door wardrobe', 100, 80 ), ( 2, 'Dining table', 1000, 560 ), ( 3, 'Towel holder', 10000, 5.50 ), ( 4, 'Computer desk', 350, 100 ), ( 5, 'Chair', 3000, 210.64 ), ( 6, 'Single bed', 750, 99 ); SELECT id, name FROM products WHERE price<10 OR price>100;
run
|
edit
|
history
|
help
0
Sql varchar to date
af
Co-Related sub query
SS Sqlsvr2014 practice
TestTaskSolutionByTania
sadasd
Crea, confirma y despliega tablas
Xml Excercise 2
STACK
SQL Stringdata