Login Register

db\Query union()

union() public method

Appends a SQL statement using UNION operator.

public $this union ( $sql, $all = false )
$sql	string\|yii\db\Query	The SQL statement to be appended using UNION
$all	boolean	TRUE if using UNION ALL and FALSE if using UNION
return	$this	The query object itself

Links:

http://www.yiiframework.com/doc-2.0/yii-db-query.html#union()-detail

doc_Yii

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\Query $union $union public property This is used to construct the UNION clause(s) in a SQL statement. Each array element is an array of the following structur

db_query db_query($query, array $args = array(), array $options = array()) Executes an arbitrary query string against the active database. Use this function f

db\Query scalar() scalar() public method Returns the query result as a scalar value. The value returned will be the first column in the first row of the query resu

db\Query batch() batch() public method Starts a batch query. A batch query supports fetching data in batches, which can keep the memory usage under a limit. This

db\Query max() max() public method Returns the maximum of the specified column values. public mixed max ( $q, $db = null )$q string The column name or expres