Question

asp查询记录条数的语句怎么写啊

asp 想查询符合某个条件的记录的条数，该怎么写

Answer 1

select count(*) from table where (id>10) '括号内为条件组合 record_count=rs(0) 或 select * from table where (id>10) '括号内为条件组合 record_count=rs.recordcount

Answer 2

select * from xxx(某表) where xxx>0(条件,比如:字段1>0 等) order by XXX(字段名)desc 很简单!~~~``