Last updated November 23, 2012. Created by drupalshrek on November 23, 2012.
Log in to edit this page.
Distinct
Some SQL queries may produce duplicate results. In such cases, duplicate rows may be filtered out using the "DISTINCT" keyword in a static query. In a dynamic query, use the distinct() method.
<?php
// Force filtering of duplicate records in the result set.
$query->distinct()
?>Note that DISTINCT can introduce a performance penalty, so do not use it unless there is no other way to restrict the result set to avoid duplicates.