590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tb1(ID int PRIMARY KEY,col decimal(10,2))
INSERT tb1 SELECT 1 ,26.21
UNION ALL SELECT 2 ,88.19
UNION ALL SELECT 3 , 4.21
UNION ALL SELECT 4 ,76.58
UNION ALL SELECT 5 ,58.06
UNION ALL SELECT 6 ,53.01
UNION ALL SELECT 7 ,18.55
UNION ALL SELECT 8 ,84.90
UNION ALL SELECT 9 ,95.60
CREATE TABLE tb2(ID INT IDENTITY PRIMARY KEY,Mindata decimal(10,2),
Maxdata decimal(10,2),Description varchar(20))
INSERT tb2(MinData,MaxData,Description)
SELECT null,30,'<30' UNION ALL
SELECT 30,60,'>=30 AND <60' UNION ALL
SELECT 60,70,'>=60 AND <70' UNION ALL
SELECT 70,80,'>=70 AND <80' UNION ALL
SELECT 80,90,'>=80 AND <90' UNION ALL
SELECT 90,null,'>=90'
select * from
(select * from [dbo].[tb2]) as refTable
where (? < Maxdata OR Maxdata IS NULL) AND (? >= Mindata OR Mindata IS NULL)