MySQL Forums
Forum List  »  Newbie

Finding Null
Posted by: Michael Smith
Date: March 14, 2023 01:18PM

Sometimes I get extra rows added to a table that I don't want.

I can identify these rows because the invnbr (Invoice Number) is NULL.

I have tried to identify these rows with code like:

SELECT COUNT(ITEM) FROM Invoices01 AS V1 WHERE invnbr = 'NULL';

But this code does not seem to work.

How should this be written?

Mike

Options: ReplyQuote


Subject
Written By
Posted
Finding Null
March 14, 2023 01:18PM
March 15, 2023 02:32AM
March 15, 2023 03:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.