Linux Today: Linux News On Internet Time.

Eliminating Duplicate Rows from MySQL Result Sets

Nov 12, 2010, 20:05 (0 Talkback[s])
(Other stories by Rob Gravelle)

"The go to solution for removing duplicate rows from your result sets is to include the distinct keyword in your select statement. It tells the query engine to remove duplicates to produce a result set in which every row is unique. Did you know that the group by clause can also be used to remove duplicates? If not, read on to find out what the main differences are between them and which to use to produce a desired result.

"The Distinct and Distinctrow Keywords

"The distinct keyword comes directly after the SELECT in the query statement and replaces the optional all keyword, which is the default. Distinctrow is an alias for distinct and produces the exact same results:"

Complete Story

Related Stories: