日期:2014-05-18 浏览次数:20536 次
declare @表A table (列1 int,列2 int,id int)
insert into @表A
select 12,16,1 union all
select 13,19,2 union all
select 0,5,3 union all
select 25,61,4 union all
select 20,10,5
select * from @表A where 列2-列1>5
/*
列1 列2 id
----------- ----------- -----------
13 19 2
25 61 4
*/
select * from @表A where abs(列2-列1)>5
/*
列1 列2 id
----------- ----------- -----------
13 19 2
25 61 4
20 10 5
*/