Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT COUNT(*) with UNION
Message
From
03/01/2013 13:55:04
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
02/01/2013 21:14:54
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: SELECT COUNT(*) with UNION
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01561145
Message ID:
01561318
Views:
53
>Is there a way to have a SELECT COUNT(*) syntax in a UNION? I would like to sum the count of both SQLs.
SELECT COUNT(A.PK)+COUNT(B.PK)
           FROM A
           FULL JOIN B ON 0=1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform