SQL查询大于某个值

你的wpjy_id这一列是什么类型的，是int型的话sql="select top 1 * from wpjy where wpjy_id >"&id &" order by wpjy_id asc"应该就可以了，如果是varchar之类的字符型的话要先转型才能跟int型的id比大小的，sql="select top 1 * from wpjy where cast(wpjy_id as int) >"&id &" order by wpjy_id asc"

例如现有表1和表2，两个表里各有一个字段Q里面存放各种可能相同的数据，现在要查询出两个表中字段Q里数据出现次数总计大于10的数据。

SELECT Q,COUNT(*) 出现总次数

FROM (SELECT Q FROM 表1 UNION ALL SELECT Q FROM 表2)

GROUP BY Q

HAVING COUNT(*)>10

以此内推

表 a ....,total,..

.表 b  ...,total,...

查询 a,b 中 total 含有  各种可能相同的数据

select * from a

where total in (select total from a group by total having count(total) >10)

union

select * from b

where total in (select total from b group by total having count(total) >10)

rs.Open "select 温度 from " + bm + " where 温度 >" + Text1.Text, conn ' 注意from后面跟一空格

也可写成rs.Open "select 温度 from " &bm &" where 温度 >" &Text1.Text, conn ' 注意from后面跟一空格

---