/**
* Erzeugt das Select-Statement für eine MSSQL-Datenbank
* @return string
*/
protected function generateSelectQuery()
{
$result = parent::generateSelectQuery();
if ($this->hasLimit()) {
$result .= " offset {$this->skip} rows fetch next {$this->rows} rows only";
}
return $result;
}
protected function generateSelectQuery()
{
$result = parent::generateSelectQuery();
if ($this->hasLimit()) {
$result .= " limit {$this->rows} offset {$this->skip}";
}
return $result;
}
/**
* Erzeugt das Select-Statement für eine MySQL-Datenbank
* @return string
*/
protected function generateSelectQuery()
{
$result = parent::generateSelectQuery();
if ($this->hasLimit()) {
$result = str_replace('select', "select first {$this->rows} skip {$this->skip}", $result);
}
return $result;
}
