[sonal1]

SELECT count(*) AS cust_not_123_total FROM orders WHERE customer_id <> '123'



hello all i am stuck here when i am work on this query pls tell me what to do now

[ronrich]

Hello sonal1,

That will give you the number of registers in your orders table that have a customer id different than '123'

Kindly

[phoolsinha]

The obvious answer is 85 (i.e, 100 - 15). However, that is not necessarily correct. Specifically, any records with a customer_id of NULL will not be included in either count (i.e., they won’t be included in cust_123_total, nor will they be included in cust_not_123_total). For example, if exactly one of the 100 customers has a NULL customer_id, the result of the last query will be:
+--------- ----------+
| cust_not_123_total |
+--------------------+
| 84 |
+--------------------+

This can solve your doubt but thorough reference is needed then visit
https://intellipaat.com/tutorial/sql-tutorial/

[amosbatto]

sonal1,
If you don't want to count records which have an ID of "1", "2" or "3", you need to do this:
SELECT count(*) AS cust_not_123_total FROM orders WHERE customer_id not in ('1', '2', '3')

[MicahDam]

Excellent read, Positive site, where did u come up with the information on this posting? I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work