Remove duplicate list entries

Hi, I have a messaging system where the system gets new messages that the current user has not yet read.

The problem is, if User A sends two messages to the current user, the list view has two entries: User A and User A.

So is there any way to remove duplicate entries?

-- 

which SQL statement do you use currently to get the list?

-- 

-- 

add a GROUP BY clause to your SQL statement like this

  GROUP BY SendingUser

see also SQL Reference Documentation of the Fusion Tables API.

--