Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Count total records
--PostgreSQL 9.6 --'\\' is a delimiter --create a table CREATE TABLE product( product_id INT PRIMARY KEY NOT NULL, sku CHAR(50) NOT NULL, category VARCHAR(50) NOT NULL, date TIMESTAMP, price DECIMAL (10,2) ); --insert dataset INSERT INTO product (product_id, sku, category,date, price)VALUES (101, 'A113M1','Mascara', '2020-04-23', 23),(102,'A212M2', 'Mascara', '2020-02-12', 23),(103,'A221NP2','Nail Polish', '2020-03-07', 15), (104, 'A332NP2','Nail Polish', '2020-05-21', 15),(105 , 'A36LIPG','Lipgloss', '2020-07-15', 19); --count total records SELECT COUNT (*) AS "total records" FROM product;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Yy
1097. Game Play Analysis V
Search Results Web results Get month name from number in PostgreSQL
timestamp sample
SQL social network practice by Han Wang 20200720 - 2
FINALE fdjfnkds
1225. Report Contiguous Dates
loggin_trigger-audit
Query integer in text field - Seemingly doesn't work as expected
Postgres CrossTab for query with variable number of columns
Please log in to post a comment.