摘要:
select count(*) from vote group by contents select count(*) from (select TOP 100 PERCENT * from vote order by contents)as A group by contents select * from vote --统计 1 和 2 和 3 的个数 显示一个表 默认升序 [第一个是... 阅读全文
摘要:
use test select * from vote insert into vote (contents) values(GETDATE()) insert into vote (contents,timess,AAA) values ('ss',GETDATE(),GETDATE()) --插入数据时 不能为空值的列名必须 写上, 能为空的可以不写 select AAA from vote... 阅读全文