Sql round error

Hi can someone please help me to find out why I’m getting the following errors in my code

‘The Round function requires 2 to 3 arguments’

Incorrect syntax near ‘(‘-

Incorrect syntax near ‘shot_level_data’-

    player_last_name, game_id,
    round((accurate_shots / total_shots) * 100) AS accuracy_pct

Can someone please let me know how I can turn on the numbers of the levels in sql server so I can fix syntax

Maybe you have forgotten to add how many decimals you want to round?
Normally ROUND(value,0)

Thank you, I’m a newbie so i forgot.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.