/** * Compile a SQL SELECT statement from a Query instance. * * @param Query $query * @return string */ public function select(Query $query) { $sql = parent::components($query); // SQL Server does not currently implement an "OFFSET" type keyword, so we // actually have to generate the ANSI standard SQL for doing offset like // functionality. OFFSET is in SQL Server 2012, however. if ($query->offset > 0) { return $this->ansi_offset($query, $sql); } // Once all of the clauses have been compiled, we can join them all as // one statement. Any segments that are null or an empty string will // be removed from the array before imploding. return $this->concatenate($sql); }
public function select(Query $query) { $sql = parent::components($query); if ($query->offset > 0) { return $this->ansi_offset($query, $sql); } return $this->concatenate($sql); }