ZF2 WHRE句に副問い合わせ

zf2-subquery-where.php

<?php
$sm = $this->getServiceLocator();
$adapter = $sm->get('Zend\Db\Adapter\Adapter');
$sql = new \Zend\Db\Sql\Sql($adapter);
$select = $sql->select();
$select->from('album');

//副問い合わせ用selectオブジェクト
$subselect = $sql->select();
$subselect->from('album');
$subselect->columns(array(
    'latest_release' => new \Zend\Db\Sql\Predicate\Expression('MAX(album.release_date)')
));

//WHERE句に副問い合わせを指定
$select->where(array(
    'release_date' => $subselect
));

//echo $select->getSqlString($adapter->getPlatform());
$statement = $sql->prepareStatementForSqlObject($select);
$resultSet = $statement->execute();

//SELECT `album`.* FROM `album` WHERE `release_date` = (SELECT MAX(album.release_date) AS `latest_release` FROM `album`)