Group by en with Subqueries Sql SErver

Question

Group by en with Subqueries Sql SErver

Navigation

#1 by (0 votes)

0

I would like only 3 count only the amounts

select ( select count(DISTINCT concat(U_codpro,U_codemp)) from [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC] where U_codpro = '201803EMP') as [a],
( select count(DISTINCT concat(U_codpro,U_codemp)) from [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC] where U_codpro = '201803OBR') as [c] ,
( select count(DISTINCT concat(U_codpro,U_codemp)) from [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC] where U_codpro = '201803LBSOBR') as [p]
 from [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC] a where U_codpro like '201803%' group by U_codemp/*1,2,3*/--[a],[c],[p]

sql-server

asked by Dannylo Ramos 29.08.2018 в 05:48

source

1 answer

Errors by json not loaded when placing points in gmaps mysqli_query empty

score 0 · Answer 1

Zero that this is what you are looking for. Without more information of your question I can not help you anymore.

SELECT
    [201803EMP],
    [201803BR],
    [201803LBSOBR]
FROM
    (SELECT DISTINCT
        U_codpro,
        U_codemp
    FROM
        [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC]
    ) AS Datos
PIVOT
(
    COUNT(U_codemp)
    FOR U_codpro IN ([201803EMP], [201803BR], [201803LBSOBR])
) AS Resultado