SQL查询和OR BETWEEN在同一个查询中 [英] SQL query AND OR BETWEEN in same query

问题描述

OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND  NameOfUnit=? AND GPFcategory=? AND SDATE BETWEEN @date1 and @date2 AND PoNo1 <> ? OR  PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ?  ORDER BY SlipNo ASC", con);

大家好，

我将参数传递给此代码以及为什么我会得到结果只是基于其他条件，除了SDATE BETWEEN @ date1和@ date2。

请帮我找出错误或给我一些解决方案或想法。

谢谢。

Hi everyone,
I am passing parameter to this code and why i am getting result only on the basis of other condition except SDATE BETWEEN @date1 and @date2.
please help me to find out error or give me some solution or idea.
thank you.

推荐答案

Yipee！我通过你的帮助朋友解决了这个问题



我这样修改我的代码



OleDbCommand cmd = new OleDbCommand（select * from Salary where（GPFCPF =？AND NameOfUnit =？AND GPFcategory =？AND PoNo1<>？或PoNo2<>？OR PoNo3<>？或PoNo4< >？或PoNo5<>？或PoNo6<>？或PoNo7<>？或PoNo8<>？AND（在@ date1和@ date2之间的SDATE）ORDER BY SlipNo ASC，con） ;



它有效。

虽然我不明白我的问题中先前代码的问题是什么。如果有人可以告诉我这对将来非常有用。

给你朋友谢谢。

Yipee! I solved it through your help friends

I modify my code like this

OleDbCommand cmd = new OleDbCommand("select * from Salary where (GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) AND (SDATE BETWEEN @date1 and @date2) ORDER BY SlipNo ASC", con);

And it works.
Though i don't understand what was the problem with previous code in my question. if someone can tell me that would be very useful for future.
THanks to you Friends.

OleDbCommand cmd = new OleDbCommand（select * from the GPlary GPFCPF =？AND NameOfUnit =？AND GPFcategory =？AND（SDATE BETWEEN @ date1和@ date2）AND（PoNo1<>？OR PoNo2<>？或PoNo3<>？或PoNo4<>？OR PoNo5<>？或PoNo6<>？或PoNo7<>？或PoNo8<>？）ORDER BY SlipNo ASC，con）;



这可以用，因为分析仪需要分离阅读条件

OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND (SDATE BETWEEN @date1 and @date2 )AND (PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ?) ORDER BY SlipNo ASC", con);

This would work as analyzer requires seperation of conditions for reading purpose

这篇关于SQL查询和OR BETWEEN在同一个查询中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！