25/02/2006, 08:55
|
| | | Fecha de Ingreso: noviembre-2005
Mensajes: 658
Antigüedad: 18 años, 6 meses Puntos: 3 | |
| Asi
SELECT id_area,id_encuesta
CASE id_resp
WHEN '1' THEN count(id_resp)
END AS r1,
CASE id_resp
WHEN '2' THEN count(id_resp)
END AS r2,
CASE id_resp
WHEN '3' THEN count(id_resp)
END AS r3,
CASE id_resp
WHEN '4' THEN count(id_resp)
END AS r4
FROM resp_encuesta
GROUP BY id_area,id_encuesta
ORDER BY id_area,id_encuesta |