sqlite常用查询

--查询版本
SELECT sqlite_version() AS ‘SQLite Version‘;

CREATE TABLE [Users] (
    [ID] integer, 
    [UserName] nvarchar(254), 
    [Password] nvarchar(254), 
    [Group] int
);


insert into users values(1,‘test1‘,‘password‘,1);
insert into users values(2,‘test2‘,‘password‘,3);
insert into users values(3,‘test3‘,‘password‘,1);
insert into users values(4,‘test4‘,‘password‘,2);

--字段拼接 ||
select username||‘-‘||password as userinfo from users

--多行合并 Group_CONCAT
SELECT [group],GROUP_CONCAT(username) users FROM users GROUP BY [group]

--top 
select * from users limit 0,3