Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
customers table
create table customers( PRODUCT_ID INT NOT NULL, PRODUCT_NAME VARCHAR(20), NAME VARCHAR(10) NOT NULL, ADDRESS VARCHAR(20), PRIMARY KEY (PRODUCT_ID, PRODUCT_NAME) ); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (1, 'Mugs', 'Deekshitha', 'vishakapatnam'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (2, 'vases', 'shabbu', 'vishakapatnam'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (3, 'Mugs', 'lasya', 'hyderabad'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (4, 'Mugs', 'sohel', 'vishakapatnam'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (5, 'boxes', 'mehaboob', 'karimnagar'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (6, 'Mugs', 'sujatha', 'vishakapatnam'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (7, 'boxes', 'monal', 'warangal'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (8, 'Mugs', 'akhil', 'vijayawada'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (9, 'vases', 'abhijeeth', 'guntur'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (10, 'plant holder', 'priya', 'vishakapatnam'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (11, 'mugs', 'shiva', 'warangal'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (12, 'Mugs', 'rajashekar', 'guntur'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (13, 'boxes', 'divi', 'hyderabad'); INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (14, 'Mugs', 'Devi', 'vijayawada'); SELECT * FROM CUSTOMERS;
run
|
edit
|
history
|
help
0
abhishek
dk
MyShopSchema
Libros
sum vs count with multiple options in group by clause
Turn column into string
Calculation of a status life duration
Studiu Individual 1
Viernes
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver