有懂SQL语句的帮金光整个法子

聶十八

哈哈.你们踢了那么久累不累啊?
9 \3 _- a' f* S8 R/ T9 ~% B会MYSQL语句的帮金光写个语句.然后好让他一次性查询出来

! S. u1 w- K/ }6 A

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, subject, message  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0

zyok

不懂·······

聶十八

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, count(*)  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0
& `0 X% `8 ~7 u3 d+ _6 i' R% S

这个只看发帖者.并显示踢中次数
哈哈.MYSQL不会.真累
2 C: I" w8 W6 E# |; z  V7 E& w! O8 G还是MSSQL比较容易懂

vica

  x* y7 O9 W+ N
. m: Z& z$ @% }+ q8 w) \貌似只能按回复的pid排序，没有楼层数的字段。

zyok

高手········

聶十八

vica 发表于 2010-11-22 08:22

                               
登录/注册后可看大图

/ D6 U, E+ ]1 t貌似只能按回复的pid排序，没有楼层数的字段。

. _0 a, ^& X" X' |  }哈哈。我就是按PID排序后再确定楼层的

三叶草

高手，mysql和mssql大体上是一致的，可能函数名不一样，或者mysql不支持太复杂的子查询

聶十八

mssql的话可以用
select distinct identity(int,1,1) ............ into
1 [# ?2 V$ T; E) v8 z7 y 来生成楼层数

金光

聶十八 发表于 2010-11-22 00:55

7 U; @5 ^& I0 k! c                               
登录/注册后可看大图

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a. ...

2 T: f9 L9 q& a8 H9 [, ]& LMySQL 返回：
0 Q+ Z1 k+ a9 P) _6 j
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
1 h; |- `9 v! b% D# Q% K
$ z  i4 E; D4 H$ L+ b

金光

聶十八 发表于 2010-11-22 00:51

                               
登录/注册后可看大图

哈哈.你们踢了那么久累不累啊?
会MYSQL语句的帮金光写个语句.然后好让他一次性查询出来

. [  B7 V  P- Q7 l: n0 z" Z& ^0 kselect ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, subject, message  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0