Hi all,<br><br>I have yet another query that I am having trouble running with Monet, and I am hoping a seasoned expert can help me figure out what is going on here.<br><br>My query is:<br>SELECT fid, title, D0 AS ed FROM signatures t WHERE fid = ( SELECT fid FROM signatures ti WHERE ti.guid = t.guid ORDER BY D0 ASC LIMIT 1 OFFSET 1) ORDER BY D0 ASC, fid DESC;<br>

<br>but I am getting the error:<br>&quot;!syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or &#39;)&#39; in: &quot;select fid, title, d0 as ed from signatures t where fid = ( select fid from signatures ti where ti.guid = t.guid order&quot;<br>

<br>So it appears to not like the ORDER BY term, and I can&#39;t figure out why.<br><br>I am trying to grab the second element (after ordering by D0) based on distinct GUIDs. The query iteself is based on the answer for a question from stackoverflow that I posted: <a href="http://stackoverflow.com/questions/4634068/sql-query-with-order-by-part-2">http://stackoverflow.com/questions/4634068/sql-query-with-order-by-part-2</a> <br>

<br>Can anyone help me figure this out? The syntax looks fine to me. By the way, I have &quot;D0 AS ed&quot; because D0 will eventually be replaced with a simple math operator (i.e., D0/D1).<br><br>Many thanks,<br>Brett<br>