SQL常用语句

select * from user_data

insert into user_data(number,name) values(#{number},#{name})

delete from user_data where number = #{number}

update user_data set name = #{name} where number = #{number}

select * from user_data where number between #{low} and #{high}

<!-- 从第start行开始读取length行 -->
SELECT * FROM user limit #{start}, #{length};

SELECT * FROM Websites
WHERE name LIKE 'G%'

SELECT * FROM Websites
WHERE name NOT LIKE '%G%'

cast(stringType as numeric(18,12))

array_agg(distinct transCode) as transCode