Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

 
HAVING <having condition>
By patvdv at 26 Feb 2008 - 21:56

HAVING <having condition>

The HAVING clause sets conditions on groups defined by the GROUP BY clause (that is, HAVING does for groups what WHERE does for records). If you use a HAVING clause, you must specify a GROUP BY clause also. The elements in the <having condition> can be either elements from the <group condition> in the GROUP BY clause or functions on fields from the tables in the <from list> of the FROM clause. The <having condition> can contain arithmetical and string expressions. For example:

 SELECT ttadv200.cpac, ttadv200.cmod, ttadv200.cses, count(*)
 FROM ttadv200
 GROUP BY ttadv200.cpac, ttadv200.cmod, ttadv200.cses
 HAVING count(*) > 1

Related topics


0
No votes yet


All times are GMT +2. The time now is 04:59.


©2001-2018 - Baanboard.com - Baanforums.com