Query on HANA SQL Query Calculation

[former_member751591]

I am new to HANA, and was trying to write a SQL for finding standard deviation: select stddev(values) as stddev For example, the values are 6.8,10.2 and 3.4. When I am executing it in HANA, I am getting result as 3.39999. But when I try to calculate it manually, or by excel, it shows 3.4.

Similarly, for different example, I get 5.1999 in HANA, but in excel/manual check it shows 5.2.

What can be the reason/fix for this?

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[Vitaliy-R]

What is the data type of the table column, where your `values` are stored?