22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM BTTitle
WHERE (convert(decimal(10,2),[List Price]) * convert(decimal(10,2),[Discount Key]) < 60)
SELECT *
FROM BTTitle
WHERE (cast([List Price] as real) * cast([Discount Key] as real) < 60)
sql语句如下:
SELECT *
FROM BTTitle
WHERE (convert(float,[List Price]) * convert(float,[Discount Key]) < 60)