|
|
CREATE TABLE test ( email VARCHAR(13),
carrier VARCHAR(10),
id INTEGER,
d_date TIMESTAMP );
INSERT INTO test (email, carrier, id, d_date) VALUES
('email_1', 'car_1', '1', '2019-02-08'),
('email_1', 'car_1', '1', '2019-02-09'),
('email_1', 'car_1', '2', '2019-02-10'),
('email_1', 'car_2', '2', '2019-02-11'),
('email_2', 'car_3', '3', '2019-02-09'),
('email_2', 'car_4', '4', '2019-02-09');
SELECT * FROM test;
| email |
carrier |
id |
d_date |
| email_1 |
car_1 |
1 |
2019-02-08 00:00:00 |
| email_1 |
car_1 |
1 |
2019-02-09 00:00:00 |
| email_1 |
car_1 |
2 |
2019-02-10 00:00:00 |
| email_1 |
car_2 |
2 |
2019-02-11 00:00:00 |
| email_2 |
car_3 |
3 |
2019-02-09 00:00:00 |
| email_2 |
car_4 |
4 |
2019-02-09 00:00:00 |
| … |
|
