Benutzer-Werkzeuge

Webseiten-Werkzeuge


snippets:not_distinct

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 ;
snippets/not_distinct.txt · Zuletzt geändert: 22.02.2010 03:46 (Externe Bearbeitung)