Click here to Skip to main content
15,614,809 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi Friends,

In sql I have 2 record in my table. I want return null if my value is not available. But I am getting data.

Could anyone help on this?


What I have tried:

I tried this.

FROM Log_Interface_Service_Status_Bimbo
AND LISS_Service_Name IN ('RetailerHierarchyWorkerServiceV1','ProductWorkerServiceV1','PriceWorkerServiceV1')
AND LISS_Status = 'Completed'

Here I want return null, because PriceWorkerServiceV1 is not available in my table. So I want null only. How can I build query
Updated 27-Dec-22 23:42pm

1 solution


If you look closely, you where clause would tell you why you're getting records even when "one" of the values in service name do not exist.
The Where ** IN clause lets you choose between different values and return a record that matches any one of them.
SQL IN Operator[^]

If you want to return records only when your condition is met, use the Where clause instead of the Where ** IN clause.
Share this answer
Gunasekaran Krishnamoorthy 28-Dec-22 5:50am    
But in where condition how can I use these 3 values ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900