关于成绩查询??? select xh from cj1999 where cj between '00.00' and '59.99' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select count(*) as 人数 from cj1999 where cj between 0.0 and 60.0 select count(*) as 人数 from cj1999 where cj between '0.0' and '60.0' select xh from cj1999 where convert(float,cj)<60.0 and convert(float,cj)>=0.0 select 人数=count(*) from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1') --测试create table cj1999(name varchar(10),cj char(4))insert cj1999 values('zhangzs1','a')insert cj1999 values('zhangzs2','-1')insert cj1999 values('zhangzs3',' ')insert cj1999 values('hongyl','10')insert cj1999 values('zhangsan1','70')insert cj1999 values('zhangsan2','60')insert cj1999 values('lisi1','60.1')insert cj1999 values('lisi2','55')insert cj1999 values('lisi3','90')insert cj1999 values('lisi4','an')select *from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1')select 人数=count(*) from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1')drop table cj1999--结果name cj ---------- ---- hongyl 10 zhangsan2 60 lisi2 55 (所影响的行数为 3 行)人数 ----------- 3(所影响的行数为 1 行) 如果你字段里还有类似-2,-3的,那就不行了 ^_^用下面的吧:select 人数=count(*) from cj1999 where (cj between '0.00' and '60.00') and (left(cj,1)<>'-') 关于MS SQL Server恢复的问题 苦思无果 求救 :sql 存取款时间段的算法 如何让自定义函数只执行一次? Sql 字符串拆分 将MS SQL SERVER的sql语句改成MYSQL的,在线等!谢谢! 一个SQL的难题,大家帮帮尽快 SQL优化 @符号在sql server 中是什么意思啊 Index Server的查询问题? 关于求库存的问题,不知大家采用那一种方法! distinct为什么无效了? 能在where子句中写这样的case语句吗?
from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1')
create table cj1999(name varchar(10),cj char(4))
insert cj1999 values('zhangzs1','a')
insert cj1999 values('zhangzs2','-1')
insert cj1999 values('zhangzs3',' ')
insert cj1999 values('hongyl','10')
insert cj1999 values('zhangsan1','70')
insert cj1999 values('zhangsan2','60')
insert cj1999 values('lisi1','60.1')
insert cj1999 values('lisi2','55')
insert cj1999 values('lisi3','90')
insert cj1999 values('lisi4','an')select *
from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1')select 人数=count(*)
from cj1999 where (cj between '0.00' and '60.00') and (cj<>'-1')
drop table cj1999--结果name cj
---------- ----
hongyl 10
zhangsan2 60
lisi2 55 (所影响的行数为 3 行)人数
-----------
3(所影响的行数为 1 行)
用下面的吧:select 人数=count(*)
from cj1999 where (cj between '0.00' and '60.00') and (left(cj,1)<>'-')