How does SQL count and remove duplicate data records? If the record is duplicated without statistics, it will be counted as 0, and only those that are not duplicated will be counted.

as mentioned above, I want to count the number of records in the database. If a field is required to repeat, the count is 0. For example: a database of car sales invoices, in which there is a frame number field referred to as CJHM. I want to count the number of cars sold that month, but remove the same record as CJHM. That is, if two records have the same CJHM, neither record is counted. For example, the following table:
ID CJHM XSSJ
1 ljh908 2018-06-07
2 ljh908 2018-06-07
3 33ert78 2018-06-10
4 9087jh1 2018-06-23

Statistical results are required to be shown as: 2, that is, two records with the same CJHM are removed

Oracle mysql sql

May.22,2021

SELECT COUNT(1)
FROM (
    SELECT 1
    FROM `car`
    GROUP BY `CJHM`
    HAVING COUNT(1)=1
) a;

without considering efficiency:
select count (CJHM) from CarTable a
where (a.CJHM) not in (select CJHM from CarTable group by CJHM having count (*) > 1)

Previous: C Epoll socket read Connection reset by peer

Next: Why can't symbolic variables be logarithmic in Python's sympy?

On the Database query Optimization of java programmers in interview
background: 1. I am a java programmer 2. Recently interviewed for a senior development position 3. The previous project mainly used less oracle,mysql, and the companies interviewed basically used mysql s 4. I am weak in the database 5. Recently, I...

Oracle mysql sql java

Feb.27,2021
Can anyone share the advanced experience of sql sentences?
is there any way? such as recommended books, blogs, etc. ...

Sqlserver oracle mysql sql

Mar.11,2021
How to implement like multiple wildcard characters in sql?
there is a problem. What should I do if I want to take a record that matches multiple characters in a field? select * from actor where last_name like ( % DAVI% , MOSTEL% , ABC , kkk%aa ) the above sql statement is incorrect. Like does not sup...

Oracle mysql sql

Mar.14,2021
The problem of sql Multi-table query
1. If you use select * from APowerB without any conditions, the result will be displayed associated with tables an and b, but the result will be repeated many times 2, and select * from a join b, will not add any query conditions, and the result will b...

Oracle mysql sql

Mar.18,2021
Why do regular expressions run differently in different databases?
select regexp_replace (regexp_replace) Yu 0min Za , , ), [ u4e00 - u9fa5. The running result of ORACLE ORACLE] {1,} , U4e00 - u9fa5. The result of Yu Minli GP running:?? The result of HIVE running in Yu 0 min Za:? 0Za Why are the res...

Oracle mysql sql

Mar.21,2021
How to solve the problem of data loss in multi-table join table query?
use leftJoin multi-table join lookup. Finally, a field in select is a field from count in one of the right tables, but if there is no count data in that table, the entire query will lose the result. Now you want to keep the data in the left table if the...

Database mssql oracle mysql sql

Nov.25,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b36da7-2b89c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b36da7-2b89c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?