Sql server® 2012 t-sql fundamentals

HAVING COUNT(*) > 1

Recall that the GROUP BY phase created 16 groups of employee ID and order year. Seven of those 

groups have only one row, so after the HAVING clause is processed, nine groups remain. Run the fol-

lowing query to return those nine groups.

SELECT empid, YEAR(orderdate) AS orderyear 

FROM Sales.Orders 

WHERE custid = 71 

GROUP BY empid, YEAR(orderdate) 

HAVING COUNT(*) > 1;

This query returns the following output.

empid       orderyear 

----------- ----------- 

1           2007 

3           2007 

5           2007 

6           2007 

8           2007 

1           2008 

2           2008 

4           2008 

7           2008 

 

(9 row(s) affected)

The 

SELECT

 Clause

The SELECT clause is where you specify the attributes (columns) that you want to return in the result 

table of the query. You can base the expressions in the SELECT list on attributes from the queried 

tables, with or without further manipulation. For example, the SELECT list in Listing 2-1 has the follow-

ing expressions: empid, YEAR(orderdate), and COUNT(*). If an expression refers to an attribute with no 

manipulation, such as empid, the name of the target attribute is the same as the name of the source 

www.it-ebooks.info

---