Home / Questions / 323919
Accepted
Soy César Mora
Asked: 2020-01-24 05:53:01 +0800 CST 2020-01-24 05:53:01 +0800 CST

Add an independent value to tuples / rows in database

  • 772

If I have one select * from personasthat returns the following:

   Nombre   | Valor
   ----------------- 
    Carlos  |   10
   ----------------- 
    Miguel  |   20

Can I in my query add a specific value - that can be obtained through sub-queries - for each tuple?

    Nombre  | Valor
   ----------------- 
    Carlos  |   10 (+5 #Este numero se trae de una sub-consulta)
   ----------------- 
    Miguel  |   20 (+10, #Este numero se trae de una sub-consulta)

What I want is to get the following:

Nombre  | Valor
   ----------------- 
    Carlos  |   15
   ----------------- 
    Miguel  |   30
sql

2 Answers

  1. If I could do it directly:

     select t01.valor + (select t02.valor2 from tabla t02 where condicon) as total
 from tabla_nombre t01
    • 1
  2. Best Answer

    It can be used + (valor)after the column name to add the respective value.

    This only works for numeric columns, if the column is a string or another type, try to use some function that allows you to cast the value to a numeric one.

    If you are working with grouped columns you can use the + (valor)within aggregate functions considering the above.

    sum(campo + 50)

    This will sum +50for each tuple/row that has been grouped.

    • 0