Count unique numbers in R and SQL

Viewed 741

I have a data which I use in both R and SQL Server. The problem is when I search the unique numbers for a specific column in R it shows 222 and in SQL it returns 216. What's the problem that caused this difference?

The query used in SQL:

Select count(distinct ColName) from TableName

And in R:

Length(Unique(DataframeName$Colname))
2 Answers
Related