sqlite常用查詢

標籤：table   小工具   code   arc   color   insert   har   varchar   blog   

　　做的小工具用到了sqlite，在查詢上較sqlserver還是稍有差異，將常用操作匯總一下，慢慢收集和整理。　　

--查詢版本
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_CONCATSELECT [group],GROUP_CONCAT(username) users FROM users GROUP BY [group]

 

--top select * from users limit 0,3

 

sqlite常用查詢