WHERE 子句 指定用于限制返回的行的搜索条件 USE pubs SELECT type, AVG(price) FROM titles WHERE royalty = 10
怎样得到满足条件查询的行数? SELECT COUNT(*) FROM TABLE WHERE ... 是不是上面这样,没明白楼主的意思。
select count(1)[count] from table where ... --这里写条件 这样查询出来的count就是满足条件的行数或者: select * from table where ...--这里写条件 select @@rowcount [count] 这样查询出来的count也是满足条件的行数
select * from table where ...--这里写条件 lz是不是分太多了呀?
我的意思是要得到统计的行数,比如语句如下: SELECT * FROM mt_coal_weight WHERE (weight_time BETWEEN '2007-08-10' AND '2007-08-11')结果出来很多行,假如说有100行结果,我要得到100这个值。
select count(*) from tablename where ......
SELECT count(*) FROM mt_coal_weight WHERE weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 '
我的意思是要得到统计的行数,比如语句如下: SELECT * FROM mt_coal_weight WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') 结果出来很多行,假如说有100行结果,我要得到100这个值。 ---------------方法一:SELECT * FROM mt_coal_weight WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') 执行完毕后,察看“消息”会有如:(所影响的行数为 100 行)的提示。方法二:SELECT * FROM mt_coal_weight WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') select @@rowcount
*
from
t
where col1='a' and col3='...'
指定用于限制返回的行的搜索条件
USE pubs
SELECT type, AVG(price)
FROM titles
WHERE royalty = 10
SELECT COUNT(*) FROM TABLE WHERE ...
是不是上面这样,没明白楼主的意思。
select count(1)[count] from table where ... --这里写条件
这样查询出来的count就是满足条件的行数或者:
select * from table where ...--这里写条件
select @@rowcount [count]
这样查询出来的count也是满足条件的行数
lz是不是分太多了呀?
SELECT *
FROM mt_coal_weight
WHERE (weight_time BETWEEN '2007-08-10' AND '2007-08-11')结果出来很多行,假如说有100行结果,我要得到100这个值。
SELECT count(*)
FROM mt_coal_weight
WHERE weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 '
SELECT *
FROM mt_coal_weight
WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') 结果出来很多行,假如说有100行结果,我要得到100这个值。
---------------方法一:SELECT *
FROM mt_coal_weight
WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') 执行完毕后,察看“消息”会有如:(所影响的行数为 100 行)的提示。方法二:SELECT *
FROM mt_coal_weight
WHERE (weight_time BETWEEN '2007-08-10 ' AND '2007-08-11 ') select @@rowcount