SQL 上月1日

SELECT column1, column2, ...
FROM table_name
WHERE condition;

SELECT first_name, last_name
FROM employees
WHERE department = 'Sales';

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

INSERT INTO employees (first_name, last_name, department)
VALUES ('Alice', 'Smith', 'Marketing');

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

UPDATE employees
SET department = 'HR'
WHERE last_name = 'Johnson';

DELETE FROM table_name
WHERE condition;

DELETE FROM employees
WHERE first_name = 'Bob' AND last_name = 'Jones';

SELECT *
FROM your_table
WHERE DATEPART(day, DATEADD(month, -1, GETDATE())) = 1

SELECT *
FROM your_table
WHERE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) = DATEADD(day, 1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))

SELECT *
FROM orders
WHERE DATEPART(day, DATEADD(month, -1, order_date)) = 1