Sql round error

[ss.butterfly]

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’-

SELECT
    player_id,
    player_first_name,
    player_last_name, game_id,
    round((accurate_shots / total_shots) * 100) AS accuracy_pct
FROM......... 

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

[sibertius]

@ss.butterfly

The Round function requires 2 to 3 arguments

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

MySQL ROUND() Function

[ss.butterfly]

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