How to find empty columns in SQL [duplicate]

Question

I want to make a query which will give me the list of not empty data from SQL. I wrote a query but not working. Please help

SELECT * FROM [EmployeePIMSInfo] 
    WHERE [Group] = 'Dhaka' and [SalaryRuleCode] != ('Rule-EXP') and 
    [Status] = 'Active' and Designation = 'Peon' 
    and (EMail != '' or EMail is not null)

Please show sample data and desired results as formatted text — Dale K
– Dale K, Commented Sep 26, 2023 at 6:37
You can just use EMail != '' - that implicitly excludes NULL anyway here — Martin Smith
– Martin Smith, Commented Sep 26, 2023 at 6:43

Dale K · Accepted Answer · 2023-09-26 06:49:23Z

0

Use and instead of or

SELECT * FROM [EmployeePIMSInfo] 
    WHERE [Group] = 'Dhaka' and [SalaryRuleCode] != ('Rule-EXP') and 
    [Status] = 'Active' and Designation = 'Peon' 
    and EMail != '' and EMail is not null

edited Sep 26, 2023 at 6:49

Dale K

28.1k15 gold badges59 silver badges85 bronze badges

answered Sep 26, 2023 at 6:41

Nidhi257

9973 gold badges8 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Charlieface Over a year ago

and EMail != '' and EMail is not null is redundant, you can just do and EMail != '' as that excludes nulls anyway.

Nidhi257 Over a year ago

@Charlieface nulls and empty string

Charlieface Over a year ago

Again EMail != '' already excludes nulls also. See eg stackoverflow.com/a/5658472/14868997

Collectives™ on Stack Overflow

How to find empty columns in SQL [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related