我现在页面分页 是access数据库,,select top 8 distinct banner,bannerstate from info_class前面是调试出来的语句,我每页显示8条信息,banner列要求不重复,但这样写,access好像不行,因为前面又top 8,,,top 8去掉可以,,但我要取前8条怎么搞,查询语句怎么写
你看看这样行不行,效率自己测 Select distinct top 8 banner,(select top 1 bannerstate from info_class where banner=newcol.banner) from info_class as newcol
select top 8 a.banner,(select top(1) bannerstate from info_class where banner=a.banner) as bannerstate from info_class as a group by a.banner在sql server中是可以的,不知道在access中是否可以。
select top 8 distinct banner,bannerstate from info_class只要banner不重复 本身问题就很搞笑那你怎么取bannerstate,,,, 一个banner对应一个bannerstate,你只要一个banner,那bannerstate取哪个值?
--------
假设
banner bannerstate
1 1
1 0
1 1
1 0
------
你取不重复的bannerbanner bannerstate
1 ??????
你看看这样行不行,效率自己测
Select distinct top 8 banner,(select top 1 bannerstate from info_class where banner=newcol.banner) from info_class as newcol
select top 8 a.banner,(select top(1) bannerstate from info_class where banner=a.banner) as bannerstate
from info_class as a group by a.banner在sql server中是可以的,不知道在access中是否可以。