SQL: NOT DISTINCT

Variante #1:

SELECT OrderDate, COUNT(*) AS cnt FROM order_order GROUP BY OrderDate HAVING cnt >1

Variante #2:

SELECT COUNT(*), * FROM tbl_product GROUP BY modelnumber HAVING COUNT(*) > 1 ;