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