select count(*) from MultiRoom_billboard where roomid=1 -------取第一列为rs(0)
select count(*) as num from MultiRoom_billboard where roomid=1 ---------rs("num")
select count(*) from MultiRoom_billboard where roomid=1 -------取第一列为rs(0)
select count(*) as num from MultiRoom_billboard where roomid=1 ---------rs("num")