Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (2.6k points)

I wanted to use MOD function in SQL Server.

'MOD' is not a recognized built-in function name.

DECLARE @m INT

SET @m = MOD(38,5)

SELECT @m

1 Answer

0 votes
by (7.2k points)

For using the mod in MYSQL, we need to use a percent sign.

SELECT 38 % 5 would give you the modulo 3

Related questions

1.2k questions

2.7k answers

501 comments

693 users

Browse Categories

...