group the results of a query in a single row

Question

group the results of a query in a single row

Navigation

#1 by (2 votes)

1

I have a view in sqlServer in which I do the following select

SELECT mes
      ,P117_Dias_Trabajados
      ,P004_Dias_Falta
      ,P002_Dias_Permisos_CG
      ,P003_Dias_Permisos_SG
      ,P003_Dias_Licenicas_Comun
      ,P003_Dias_Licencias_Loborales
      ,P003_Dias_No_Contratados
  FROM v_TPersonal_Asistencia 
  WHERE ficha='11117454'

which gives me the following result (image1)

What I want is to show me one row for each mes (image2)

he intentado agrupar los valores por 'mes' pero me da el siguiente error:
La columna 'v_TPersonal_Asistencia.P117_Dias_Trabajados' de la lista de selección no es válida, porque no está contenida en una función de agregado ni en la cláusula GROUP BY.

and when adding the other fields it shows the same result as in the image1,

sql sql-server sql-server-2014

asked by Kevin 28.11.2017 в 13:53

source

1 answer

Loop from X to Y specified by the user a = 0.7f but at 0.7

score 2 · Accepted Answer

If you are going to group only by month, you must use aggregation functions in the rest of the columns (for example SUM ):

SELECT mes
      ,SUM(P117_Dias_Trabajados) P117_Dias_Trabajados
      ,SUM(P004_Dias_Falta) P004_Dias_Falta
      ,SUM(P002_Dias_Permisos_CG) P002_Dias_Permisos_CG
      ,SUM(P003_Dias_Permisos_SG) P003_Dias_Permisos_SG
      ,SUM(P003_Dias_Licenicas_Comun) P003_Dias_Licenicas_Comun
      ,SUM(P003_Dias_Licencias_Loborales) P003_Dias_Licencias_Loborales
      ,SUM(P003_Dias_No_Contratados) P003_Dias_No_Contratados
  FROM v_TPersonal_Asistencia 
  WHERE ficha='11117454'
  GROUP BY mes;