SELECT COUNT(*) with UNION

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SELECT COUNT(*) with UNION

Message

03/01/2013 13:55:04

02/01/2013 21:14:54

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01561145

Message ID:

01561318

Vues:

>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