开发者

Dynamic Query with AND, OR criteria

I am using Dynamic Query to get the result from my custom table.

I want to execute Dynamic Query with "AND"(&&) as well as with "or"(||) criteria.

SQL which resembles to my need is something like this

Select *开发者_开发问答 
From CustomeTable ct
Where   (ct.firstColumn = "abc" AND ct.secondColumn = "xyz")
        OR ct.thirdColumn = "123";

Please let me know if any knows the solution.

Regards, Tina

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜