求sql语句

blackmeit 2008-03-13 07:01:06
有一列小数,保留了6位有效数据。
Units
2.000000
1.222000
1.200000
3123.231


我想查出多于一位小数的数据

期望结果:
Units
1.222000
3123.231


...全文
42 点赞 收藏 6
写回复
6 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
leisure_cool 2008-03-14

declare @table table (Units decimal(18,6))
insert into @table
select 2.000000
union all
select 1.222000
union all
select 1.200000
union all
select 3123.231

select * from @table where Units<> round(Units,2)
/*
或者
*/
select * from @table where Units<> round(Units,1)

回复
dawugui 2008-03-13
create table tb(units  decimal(18,6))
insert into tb values(2.000000)
insert into tb values(1.222000)
insert into tb values(1.200000)
insert into tb values(3123.231)
go

select * from tb where (units * 100) - floor(units * 100) > 0

drop table tb

/*
units
--------------------
1.222000
3123.231000

(所影响的行数为 2 行)

*/
回复
liuyann 2008-03-13

select *
from yourTable
where Units <> INT(Units )

== 思想重于技巧 ==
回复
-狙击手- 2008-03-13
declare @t table(Units numeric(12,6))
insert @t select
2.000000 union select
1.222000 union select
1.200000 union select
3123.231

select *
from @t
where units <> round(units,1)
/*
Units
--------------
1.222000
3123.231000

(所影响的行数为 2 行)

*/
回复
-狙击手- 2008-03-13
select *
from T
where units <> round(units,1)
回复
JiangHongTao 2008-03-13
select units from tablename where right(rtrim(units),4)>'0000'
回复
相关推荐
发帖
MS-SQL Server
创建于2007-09-28

3.3w+

社区成员

MS-SQL Server相关内容讨论专区
申请成为版主
帖子事件
创建了帖子
2008-03-13 07:01
社区公告
暂无公告