Collection::reject() Collection::every() Collection::some() Collection::match() Collection::firstMatch() Aggregation Collection::reduce() Collection::min() Collection::max() Collection::sumOf() Collection::avg() 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($tags)) { // If there are no tags provided, find articles that have must return a modified query object. In our finder we’ve leveraged the distinct() and leftJoin() methods which allow us to find distinct articles that have a ‘matching’ tag. Creating the View Now if you

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733 Aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 'Articles.published', 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($tags)) { // If there are no tags provided, find articles that have no tags must return a modified query object. In our finder we’ve leveraged the distinct() and leftJoin() methods which allow us to find distinct articles that have a ‘matching’ tag. Creating the View Now if you

Locating Themes Loading Vendor Files Collections Quick Example List of Methods Iterating Filtering Aggregation Grouping and Counting Sorting Working with Tree Data Other Methods Withdrawing Elements Expanding columns on the provided table or association instance’s target table. Query::distinct() now accepts a string to distinct on a single column. Table::loadInto() was added. EXTRACT, DATE_ADD and DAYOFWEEK 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($options['tags'])) { // If there are no tags provided, find articles

Collection::reject() Collection::every() Collection::some() Collection::match() Collection::firstMatch() Aggregation Collection::reduce() Collection::min() Collection::max() Collection::sumOf() Collection::avg() 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($options['tags'])) { // If there are no tags provided, find articles must return a modified query object. In our finder we’ve leveraged the distinct() and leftJoin() methods which allow us to find distinct articles that have a ‘matching’ tag. Creating the View Now if you

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847 Aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . columns on the provided table or association instance’s target table. • Query::distinct() now accepts a string to distinct on a single column. • Table::loadInto() was added. • EXTRACT, DATE_ADD and DAYOFWEEK 'Articles.published', 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($options['tags'])) { // If there are no tags provided, find articles that

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 837 Aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 'Articles.published', 'Articles.created', 'Articles.slug', ]; $query = $query ->select($columns) ->distinct($columns); if (empty($options['tags'])) { // If there are no tags provided, find articles that must return a modified query object. In our finder we’ve leveraged the distinct() and leftJoin() methods which allow us to find distinct articles that have a ‘matching’ tag. Creating the View Now if you

row_count] Data Manipulation Language ������������ insert update delete select SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ���� Data Manipulation Language ������������ insert update delete select SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT]

DB::table('users')->get(array('id', 'email as user_email')); Selecting distinct results from the database: $user = DB::table('users')->distinct()->get(); Building Where Clauses where and or_where There

学院致力于提供优质 Laravel 中文学习资源 179  Different  Digits  Digits Between  Dimensions（图片文件）  Distinct  E-Mail  Exists (Database)  file  filled  Image (File)  In  In Array 约束应该是宽度/高度，这可以通过表达式 3/2 或浮点数 1.5 来表示： 'avatar' => 'dimensions:ratio=3/2' distinct 处理数组时，验证字段不能包含重复值： 'foo.*.id' => 'distinct' email 本文档由 Laravel 学院（LaravelAcademy.org）提供 Laravel 学院致力于提供优质 DB::table('users')->select('name', 'email as user_email') ->get(); distinct 方法允许你强制查询返回不重复的结果集： $users = DB::table('users')->distinct()->get(); 如果你已经有了一个查询构建器实例并且希望添加一个查询列到已存在的 select 子句，可以使 本文档由 Laravel

conditions 'recursive' => 1, // int // array of field names 'fields' => array('Model.field1', 'DISTINCT Model.field2'), // string or array defining order 'order' => array('Model.created', 'Model ->find('count'); $publishedAuthors = $this->Article->find('count', array( 'fields' => 'DISTINCT Article.user_id', 'conditions' => array('Article.status !=' => 'pending') )); // .. Note Don’t pass fields as an array to find('count'). You would only need to specify fields for a DISTINCT count (since otherwise, the count is always the same, dictated by the conditions). find(‘all’)