SQL Server How to select from expression?

tct7dpnv 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(101)

In PostgreSQL I can issue next query:

=> select 6 between 5 and 7;
 ?column? 
----------
 t
(1 row)

But if I run similar expression in Microsoft SQL server I get the error:

> select 6 between 5 and 7;
Server message number=156 severity=15 state=1 line=8 server=WIN-P5BDUH0CU0N text=Incorrect syntax near the keyword 'between'

How to select from expression in Microsoft SQL server?

sql-server

来源：https://stackoverflow.com/questions/76440547/how-to-select-from-expression

1条答案

按热度按时间

4xrmg8kj1#

Thank you to @ThomA and @Charlieface. Next expression works fine for me:

select IIF( 8 between 5 and 7, 1, 0 );

@Horaciux query is what I was looking for:

SELECT CASE WHEN 6 BETWEEN 5 AND 7 THEN 't' ELSE 'f' END AS Result;

赞(0）回复(0）举报 2023-06-21

我来回答

SQL Server How to select from expression?

1条答案

相关问题

热门标签

最新问答