How to skip first row in a dynamic query? I've not yet found the right way to use ->range($offset,$limit) in a dynamic query to skip first result, but without limiting the resultset (LIMIT clause).

The only workaround I've found is to use an high value for LIMIT, for example:

-&gt;range(1,99999999);


(see my comment in Drupal API documentation: https://api.drupal.org/comment/49938#comment-49938)

What's the right sintax?
You could do something like this:

// Begin query build
$query = db_select('node');
$query-&gt;fields('node', array('nid', 'title'));
$query-&gt;condition('type', 'article');
$query-&gt;condition('uid', 1);

// Get total count for query
$count = $query-&gt;countQuery()-&gt;execute()-&gt;fetchField();

// Execute range query
$start = 1;
$query-&gt;range($start, ($count - $start));
$result = $query-&gt;execute();