Sum column in sql using execute query gives varying output

Help Forum
1

Hi devs, I am summing a column and getting the column count but each time I run the query the output gives varying result. i.e the count when I run now might differ when I run in the next 10mins.I am using float as the data type.Please assist

2

Hi @RPA-botDev ,
Can you send me the query will check and update you.

Regards,
Arivu

1 Like
3

Alright this is it - select * from tableCurrency where country in (select country from table nationality where (convert(float, currencyAmount )) = 0)
Regards Arivu

4

Are you there Arivu?

5

Hi @RPA-botDev,
Are you executing the query in sql database?

Regards,
Arivu

6

I am usin uipath execute query to execute it

7

That’s OK you r running the query in sql database right.

If possible can you share the screenshots

Regards,
Arivu

8

select * from tableCurrency where country in (select country from table nationality where (convert(float, currencyAmount )) = 0)