SQL中判断奇偶数的方法

查询ID是奇数的记录
“JIOUSHU”表：

ID
1
2
3
4
5
6

SELECT * FROM JIOUSHU WHERE ID%2!=0;#适用于Mysql、SQL Server
 
 

 
 

SELECT * FROM JIOUSHU WHERE ID&1;#适用于Mysql
 
 

 
 

SELECT * FROM JIOUSHU WHERE MOD(ID,2)=1;#适用于Mysql
 
 

 
 

                                </div><div><div></div></div>
            <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-60ecaf1f42.css" rel="stylesheet">
                            </div>
</article>