jose11au

<div>
May I please ask what the is difference of using and not using brackets?<br>I am learning SQL
</div>


<div>
it's part of the arithmetic operation, just like:<br><br>(1 + 1) x 2 is different from &nbsp;1 + (1 x 2)
</div>


<div>
Thank &nbsp;you so much.<br><br>
</div>


<div>
Not sure your logic is correct.<br />
<br />
&gt;&gt;where (address_1 Is Null or address_2 Is Null or address_3 Is Null)<br />
<br />
<br />
If all addresses are null, that returns true. &nbsp;So, it will return the row.<br />
<br />
I might also suggest COALESCE. &nbsp;It takes multiple columns and returns the first non null value.<br />
<br />
Something like this:<br />

<pre><code class="code-1 nolinks" id="code-20-43285956-1"><span>where coalesce(address_1, address_2, address_3) Is not Null</span>
<span>AND</span>
<span>coalesce(First_name, Last_name) is not null</span>
</code></pre>
</div>


<div>
I think you need something more like this:<br><br>SELECT *, STUFF(<br>&nbsp; &nbsp; CASE WHEN (address_1 IS NULL AND address_2 IS NULL AND address_3 IS NULL) THEN ', Address is missing' ELSE '' END +<br>&nbsp; &nbsp; CASE WHEN (First_name IS NULL AND Last_name IS NULL) THEN ', Name is missing' ELSE '' END, 1, 2, '') AS what_data_is_bad<br>FROM dbo.Sales<br>WHERE (address_1 IS NULL AND address_2 IS NULL AND address_3 IS NULL)<br>OR (First_name IS NULL AND Last_name IS NULL)<br><br>For example:<br><br>;WITH Sales AS (<br>&nbsp; &nbsp; SELECT * FROM (VALUES<br>&nbsp; &nbsp; &nbsp; &nbsp; (1, 'address_1', NULL, NULL, 'first_name', NULL),<br>&nbsp; &nbsp; &nbsp; &nbsp; (2, NULL, NULL, NULL, NULL, 'last_name'),<br>&nbsp; &nbsp; &nbsp; &nbsp; (3, NULL, NULL, 'address_3', NULL, NULL),<br>&nbsp; &nbsp; &nbsp; &nbsp; (4, NULL, NULL, NULL, NULL, NULL),<br>&nbsp; &nbsp; &nbsp; &nbsp; (5, NULL, NULL, 'address_3', NULL, 'last_name')<br>&nbsp; &nbsp; ) AS sales(id, address_1, address_2, address_3, first_name, last_name)<br>) &nbsp; &nbsp; &nbsp; &nbsp;<br>SELECT *, STUFF(<br>&nbsp; &nbsp; CASE WHEN (address_1 IS NULL AND address_2 IS NULL AND address_3 IS NULL) THEN ', Address is missing' ELSE '' END +<br>&nbsp; &nbsp; CASE WHEN (First_name IS NULL AND Last_name IS NULL) THEN ', Name is missing' ELSE '' END, 1, 2, '') AS what_data_is_bad<br>FROM Sales<br>WHERE (address_1 IS NULL AND address_2 IS NULL AND address_3 IS NULL)<br>OR (First_name IS NULL AND Last_name IS NULL)<br><br><br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hi All,<br><br>Could I please ask if this query is correct?<br><br>Basically I am looking for data quality issues where a record is missing address details. If either address_1, address_2 or address_3 &nbsp;is populated then the record is okay.<br><br><pre><code class="code-1 nolinks" id="code-10-29215414-1"><span>select &nbsp;*</span>
<span>from Sales</span>
<span>where address_1 Is Null or address_2 Is Null or address_3 Is Null</span>
<span>AND</span>
<span>First_name is not null or Last_name is not null</span>
</code></pre>
</div>
</div>



Hi All,
Could I please ask if this query is correct?
Basically I am looking for data quality issues where a record is missing address details. If either address_1, address_2 or address_3  is populated then the record is okay.
select  *
from Sales
where address_1 Is Null or address_2 Is Null or address_3 Is Null
AND
First_name is not null or Last_name is not null

SQL - Data quality records that are missing addresses

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.