How to add 7 column in Sql?

Question

How to add 7 column in Sql?

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

I have the following query in which I get the following result:

I want to add a column for each row, Thank you very much.

SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) as "" 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 1
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 2
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 3
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 4
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 5
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 6
    UNION ALL
    SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) 
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TRAMITE = 7;

sql oracle

asked by Devin Stiven Zapata Areiza 03.04.2018 в 19:59

source

2 answers

How to copy data from the answer sheet of the form to another spreadsheet or additional send the answers directly to another spreadsheet Use of the WHERE NOT IN in Laravel

score 0 · Answer 1

You have not put much effort into your question. Reading your SQL code I guess what you try is to add the types of procedures and the amount of each type of procedure.

In SQL, you can use an aggregation function ( count ) by making a group by for the non-aggregated column (s).
I added a order by to order by that column type of procedure.

select
  ID_MODALIDAD_TIPO_TRAMITE,
  COUNT(ID_MODALIDAD_TIPO_TRAMITE)
from SOL_SOLICITUD_TPO_TRAMT_MODL 
group by ID_MODALIDAD_TIPO_TRAMITE 
order by ID_MODALIDAD_TIPO_TRAMITE;

score 0 · Answer 2

You could use pivot, here I share the documentation to give you an idea link . The query could be similar like this:

SELECT *
FROM (select
    ID_MODALIDAD_TIPO_TRAMITE,
    COUNT(ID_MODALIDAD_TIPO_TRAMITE) AS ID_MODALIDAD_TIPO_TRAMITE
    FROM SOL_SOLICITUD_TPO_TRAMT_MODL 
    GROUP BY ID_MODALIDAD_TIPO_TRAMITE 
)TBL1
 PIVOT(
     COUNT(ID_MODALIDAD_TIPO_TRAMITE)
     FOR ID_MODALIDAD_TIPO_TRAMITE IN ([a1], [2],[3],[4],[5],[6],[7])
 ) AS PivotTable

I hope you find it useful.