How to only show unique records

lintu98

Hello,

I noticed that SELECT DISTINCT has been discussed multiple times in this forum but I was not able to find a solution that worked for me. I have the following records displayed as 'view only':

NAME EMAIL STATUS
John Doe johndoe@email.com Active
Jane Doe janedoe@email.com Inactive
John Doe johndoe@email.com Active
James Baker jmakesbaker@email.com Active
Jane Doe janedoe@email.com Inactive

I only want to show distinct records based on the email field. How can I achieve this?

Thanks

allan

From the server-side, or do you want to do the uniqueness client-side? Server-side would probably be better for performance, but it will depend upon what you re requirements are. How are you getting the data at the moment?

Allan

colin

This example from this thread shows different ways of representing the same data and removing duplicates,

Colin