/** * 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; }