how to Select and display only duplicate records in mysql

  Databases

Email

Select and display only duplicate records in mysql  abd Count the duplicate records

 

Select DISTINCT auto_id_work_order, Count(auto_id) as
from
work_order_invoice_request
where
status=’Request Raised'”;

Spread the Code

Leave a Reply

avatar

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  Subscribe  
Notify of