<div>
Hi,<br />
<br />
the query returns each result as many times as it occurs in the other table.<br />
<br />
Tried a GROUP BY a.ID, but it throws the following error:<br />
<br />
Column 'A.rownum' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause<br />
<br />
Any ideas?
</div>


Hi,

the query returns each result as many times as it occurs in the other table.

Tried a GROUP BY a.ID, but it throws the following error:

Column 'A.rownum' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

Any ideas?

<div>
&gt;as many times as it occurs in the other table.<br />
well, if there are many rows in the &quot;other&quot; table, which is the condition to determine which one of those rows to take ...<br />
<br />
check out this article to see how to solve it, eventually:<br />
<a href="https://www.experts-exchange.com/A_3203.html" rel="ugc">https://www.experts-exchange.com/A_3203.html</a>
</div>


>as many times as it occurs in the other table.
well, if there are many rows in the "other" table, which is the condition to determine which one of those rows to take ...

check out this article to see how to solve it, eventually:
https://www.experts-exchange.com/A_3203.html [https://www.experts-exchange.com/A_3203.html]

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I have the following query wich is working well as an ovverride for the LIMIT used in MySQL:<br />
<br />
SELECT * FROM (SELECT row_number() OVER (ORDER BY ID) AS rownum, Name, ID FROM TABLE) AS A WHERE A.rownum BETWEEN $offset AND ($offset+$limit) ORDER BY A.rownum ORDER BY $order_by<br />
<br />
I need to join this query with another table (TABLE2) on TABLE.ID/TABLE2.ID and still keep the BETWEEN statement working for limit replacement.<br />
<br />
The query needs to be valid for MSSQL2005.<br />
<br />
Any ideas?<br />
<br />
Thanks<br />

</div>
</div>


Hi experts,

I have the following query wich is working well as an ovverride for the LIMIT used in MySQL:

SELECT * FROM (SELECT row_number() OVER (ORDER BY ID) AS rownum, Name, ID FROM TABLE) AS A WHERE A.rownum BETWEEN $offset AND ($offset+$limit) ORDER BY A.rownum ORDER BY $order_by

I need to join this query with another table (TABLE2) on TABLE.ID/TABLE2.ID and still keep the BETWEEN statement working for limit replacement.

The query needs to be valid for MSSQL2005.

Any ideas?

Thanks


MSSQL, combining LIMIT override and join

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.