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