Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
2
CREATE TABLE StoreCustomers( date text, name VARCHAR(100), product CHAR(10), price INT CHECK(price>0), id INT PRIMARY KEY ); INSERT INTO StoreCustomers VALUES ('11 August 2020', 'Gifted', 'potatoes',10, 1), ('11 August 2020', 'Bevin', 'apples', 8, 2), ('12 August 2020', 'Debra', 'bananas', 5, 3), ('12 August 2020', 'Tim', 'beans', 15, 4), ('12 August 2020', 'Brian', 'oranges', 5, 5), ('13 August 2020', 'Kuku', 'mango', 7, 6), ('14 August 2020', 'Ray', 'carrots', 6, 7), ('14 August 2020', 'Joe', 'cucumbers', 12, 8), ('18 August 2020','Stubs', 'pumkins', 11, 9), ('18 August 2020', 'Praise', 'tomatoes', 2, 10); SELECT SUM(price) from StoreCustomers where date = '12 August 2020'; SELECT * FROM StoreCustomers ORDER BY date Desc; SELECT * FROM StoreCustomers WHERE name like 'B%'; SELECT * FROM StoreCustomers WHERE name like '%b%';
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
1258. Find the Start and End Number of Continuous Ranges
prueb final
Studco
POSTGRESQL_CLOSEST_VALUE
Query for matching substring from text field in DB
book suggestion
Descriptor test
fgf
enrj
PostreSQL: Left Join
Please log in to post a comment.