0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @t as table(rowId int identity(1,1), [col1] float, [col2] float);
insert into @t([col1], [col2])
select 80, 100 union all --exception
select 0, 0 union all
select 90, 90 union all
select 110, 100 union all
select 90, 100 union all
select 100, 120 union all --exception
select 100, 100;

select * from @t
where [col1] not between 0.9*[col2] and 1.1*[col2];

fork query

edited jun 3

created jun 3 ullas