String Equivalent of Sum to Concatenate

string equivalent of Sum to concatenate

SELECT
     p.ID PersonID,
     STUFF(
         (SELECT ';' + b.description
          FROM  personrole a 
                INNER JOIN role b
                  ON a.roleid = b.id
          WHERE a.personid = p.id
          FOR XML PATH (''))
          , 1, 1, '')  AS DescriptionList
FROM person AS p
GROUP BY p.ID

• SQLFiddle Demo

OUTPUT

╔══════════╦════════════════════════════╗
║ PERSONID ║      DESCRIPTIONLIST       ║
╠══════════╬════════════════════════════╣
║        1 ║ user                       ║
║        2 ║ user;admininstrator;tester ║
╚══════════╩════════════════════════════╝

Python concatenation of string and integer sum

rootLeaf = 4
leftLeaf = 8
print("root: " + str(rootLeaf)+ " left: " + str(leftLeaf) + " sum: {}".format(rootLeaf + leftLeaf))

Here is your output:

root: 4 left: 8 sum: 12

In Python, in order to print integers, they must first be converted to strings. The .format method allows you to convert the integer argument (the sum of the two leafs) to strings. You enter a place holder where you want the string {}, and then in your .format method you can specify what that integer will be. In this case, rootLeaf + leftLeaf.

Sum of a javascript array returns a string concatenation of all the numbers

You have to use parseInt (if the numbers are Integers), parseFloat (if they are Floats) or Number (if not sure) to explicitly interpret them as numbers like:

sum = tot.reduce((a, n) => (a + Number(n)), 0);

Python 3.x - Using the sum function to concatenate strings in a list

This doesn't work. sum() is for adding up numbers, not strings. Use ''.join() instead.

>>> ''.join(['good ', 'morning'])
'good morning'

javascript (+) sign concatenates instead of giving sum?

Here value gives you a string, hence the concatenation. Try parsing it as an Number instead:

var sum = parseInt(numberOne) + parseInt(numberTwo);

See the demo fiddle.

How to aggregate and string concatenate at same time in Oracle?

Would this do?

SQL> with test (customer, product, amount) as
  2    (select 'a', 'table', 500 from dual union all
  3     select 'a', 'table', 300 from dual union all
  4     select 'a', 'chair', 100 from dual union all
  5     select 'b', 'rug'  , 50  from dual union all
  6     select 'b', 'chair', 200 from dual
  7    )
  8  select customer,
  9    listagg (product, ', ') within group (order by null) product,
 10    sum(sum_amount) amount
 11  from (select customer, product, sum(amount) sum_amount
 12        from test
 13        group by customer, product
 14       )
 15  group by customer
 16  order by customer;

C PRODUCT                  AMOUNT
- -------------------- ----------
a chair, table                900
b chair, rug                  250

SQL>

Why does sum() in python pandas concat when there is not a condition?

It seems that your second dataframe column df.columns[1] is compose by strings (e.g. 'Male' or 'Female'), so you can't perform a pd.sum(), but can do a pd.count(), which will basically count the number of rows associated with this column. As for your first example, the conditional argument pd.isin() will give you a boolean index of True and False, which as already pointed by Henry Ecker on comments, is interpreted as 1 and 0 values and consequently can be summed.

Javascript: + sign concatenates instead of giving sum of variables

you are dealing with strings here, and math operations on strings will mess up. Remember when ever you are doing math operations you have to convert the data into actual numbers and then perform the math.

Use parseInt() more Details here

Your code should change to

Vfinal = parseInt(Vinitial,10) + parseInt(acceleration,10) * parseInt(time,10);

Edit 1: If the numbers are decimal values then use parseFloat() instead

So the code would be

Vfinal = parseFloat(Vinitial) + parseFloat(acceleration) * parseFloat(time);

Is it possible to add integer values while concatenating Strings?

Yes.

System.out.println(str + (c + k)); 

You can change order of execution by adding parentheses (same way as in math).

CONCATENATE function inside SUM formula

Use INDEX to set the start row (D13) and end row (D14) cells.

=SUM(index(DayWise2019!d:d, D13):index(DayWise2019!d:d, D14))

Avoid INDIRECT.

---

Related Topics