PostgreSQL数据库常用CRUD语句

查询前几条记录SQL

 Select * FROM TABLE LIMIT  n;

倒序排列

SELECT
	* 
FROM
	TABLE 
ORDER BY
	[列名] DESC 
	LIMIT 100;

模糊查询

SELECT
	[结果中想显示的列1],
	[列2],
	[列3],
	[列4] 
FROM
	TABLE 
WHERE
	[要模糊查询的列] LIKE'%查询'
ORDER BY
	operate_date DESC 
	LIMIT 50;

查询某个时间段的数据

SELECT
	* 
FROM
	TABLE 
WHERE
	id = '2' 
	AND create_time BETWEEN '2021-12-19' 
	AND '2021-12-31';

修改某个时间段的数据

UPDATE TABLE 
SET id = '22' 
WHERE
	create_time BETWEEN '2021-12-19' 
	AND '2021-12-31';