IF语句的T-SQL

Question

与列的表：number1,number2,number3

有无查询手续：SELECT number1,number2,number3 FROM myTbl

，现在要检查

if number2 < number1 and number1 < number3 print 'OK'` 

怎么办呢？我不能写为它选择

Answer 1

问题有点不清楚，但如果你想打印条件，试试这个

if exists (SELECT * FROM myTbl where number2 < number1 and number1 < number3) 
    print 'Ok' 

Answer 2

我想你想这

if @number2 < @number1 and @number1 < @number3 
Begin 
    Print 'OK' 
End 

或者这

Select CASE WHEN (@number2 < @number1 and @number1 < @number3THEN expression1) 
Then 'OK' Else '' End 

Answer 3

如果您需要选择：

SELECT number1, number2, number3 
FROM YourTable 
WHERE 
    number2 < number1 
    AND number1 < number3 

或

SELECT 
    number1, number2, number3, 
    CASE WHEN number2 < number1 AND number1 < number3 THEN 'OK' ELSE '' END AS Res 
FROM YourTable  

Answer 4

像这样的事情？

declare @test int; 
select @test = case when number2<number1 and number1<number3 then 1 else 0 end 
     from test1 where id=3; 
if @test = 1 then print 'OK' 

SQL Fiddle

Answer 5

我想：

DECLARE @number1 int 
DECLARE @number2 int 
DECLARE @number3 int 

SELECT 
    @number1 = number1, 
    @number2 = number2, 
    @number3 = number3 
FROM myTbl 
WHERE (some condition to get only row) 

IF (@number2 < @number1 and @number1 < @number3) 
BEGIN 
    print 'OK' 
END 

Answer 6

declare @ID int = '' --im assuming you have some sort of ID and multiple rows in the table 
declare @num1 int = (select number1 from mytable where [ID] = @ID) 
declare @num2 int = (select number2 from mytable where [ID] = @ID) 
declare @num3 int = (select number2 from mytable where [ID] = @ID) 

IF @num2 < @num1 AND @num1 < @num3 
begin 
SELECT 'OK' 
PRINT 'OK' 
end 

ELSE 
begin 
SELECT'OK' 
PRINT 'OK' 
END