分类： 数据库开发技术
2011-10-25 09:48:38
create table test11(
id INTEGER,
name VARCHAR(32)
);
insert into test11 values(1, 'aaa');
insert into test11 values(2, 'aaa');
insert into test11 values(3, 'aaa');
insert into test11 values(2, 'aaa');
insert into test11 values(5, 'aaa');
commit;
select * from test11;
查找重复的行：
select *,count(id) from test11 group by id having count(id)>1;
分页查询：SELECT * FROM test11 LIMIT 2,2
