前面的话没打完,你看是不是这个意思: select 组别,count(组别)from leita group by 组别 order by 组别??按照几选几的类型进行分类统计???
按你所给的便子所说,只需要SQL排序就可!Select * From TableName Order By 彩票类型 DESC
Select * From TableName Order By addeddate DESC where 选项='36选7' Select * From TableName Order By addeddate DESC where 选项='31选7' Select * From TableName Order By addeddate DESC where 选项='22选5'
最近两个记录?很简单啊~ 如下: Select top 2 From TableName Order By addeddate DESC where 选项='36选7' Select top 2 From TableName Order By addeddate DESC where 选项='31选7' Select top 2 From TableName Order By addeddate DESC where 选项='22选5'top 2,所选记录的前两条 DESC,降序,以从时间最近的开始排
select 组别,count(组别)from leita group by 组别 order by 组别??按照几选几的类型进行分类统计???
Select * From TableName Order By addeddate DESC where 选项='31选7'
Select * From TableName Order By addeddate DESC where 选项='22选5'
如下:
Select top 2 From TableName Order By addeddate DESC where 选项='36选7'
Select top 2 From TableName Order By addeddate DESC where 选项='31选7'
Select top 2 From TableName Order By addeddate DESC where 选项='22选5'top 2,所选记录的前两条
DESC,降序,以从时间最近的开始排