1、是不是要
select ... from info
union all
select ... from bak_info
?2、
select top 10 * from info where c='一班'
select ... from info
union all
select ... from bak_info
?2、
select top 10 * from info where c='一班'
可不可以在Sql语句中查询到结果,因为用一个循环在页面上累加就必须显示全部,而我的页面没页只有10条,远远不够的
j9988写的存储过程
select ... from info
union all
select ... from bak_info
2、
select c,sum(b) as sum from info group by c
可以是可以,可是如果不是select c,是select *
难道要group by c,d,e,f,g,....
除了用SUM我也不知道再能怎么做了,
Set rs= Server.CreateObject("ADODB.Recordset")
SQLstr = "select c,sum(b) as sum from info group by c"
rs.Open SQLstr,conn,1,3