OFFSET and FETCH NEXT aka LIMIT for SQL Server in Zend Framework 2 -

how can create offset , fetch next in zf2 logic? result should following

    select * mytable   order id desc     offset 100 rows fetch next 10 rows 

as described here. when using following code

$select = $this->tablegateway->getsql()->select(); $select->order('id desc'); $select->offset(100); $select->limit(10); $resultset = $this->tablegateway->selectwith($select); 

then output is

select [mytable].*   [mytable]  order [id] desc  limit '10' offset '100' 

which not work sql server. output need 1 above.

the config in db.config.php looks following

'db_sql_server' => array(         'driver'    => 'pdo',         'dsn'       => 'dblib:host=myhost;dbname=mydatabase',         'username'  => 'myusername',         'password'  => 'mypasswort', ), 

i skiped 'db' config mysql here. , in global.php

return array(   'service_manager' => array(     'factories' => array(         /**          * adapter sql server          */         'application\db\adaptersqlserver' => function($sm) {             $config = $sm->get('config');             return new adapter($config['db_sql_server']);         },     ),   ), ) 

to refere in module.php table gateway.

i believe need change driver name in 'db_sql_server' config array from

'driver' => 'pdo' 

to

'driver' => 'sqlsrv'