Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to count common table expression

Status
Not open for further replies.
stoggers

stoggers

Vendor
May 30, 2001
93
0
0
US
Hi,

How do you count the number of rows returned by the following statement:

WITH TEMP1 (D) AS
(VALUES DATE('01/01/2004') UNION ALL SELECT (D + 1 DAY) FROM TEMP1 WHERE (D + 1 DAY) < DATE('01/02/2004'))
(SELECT D,DAYOFWEEK(D) FROM TEMP1)

Thanks,

Mike.
 
Sort by date Sort by votes
Doh!

WITH TEMP1 (D) AS
(VALUES DATE('01/01/2004') UNION ALL SELECT (D + 1 DAY) FROM TEMP1 WHERE (D + 1 DAY) < DATE('01/02/2009'))
(SELECT COUNT(*) FROM TEMP1 WHERE DAYOFWEEK(D) IN (2,3,4,5,6))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
82
tekpr00
tekpr00
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
44
pratimsingha
pratimsingha
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
73
evr72
evr72
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
73
fredericofonseca
fredericofonseca
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
48
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top