How to only show unique records

How to only show unique records

lintu98lintu98 Posts: 11Questions: 4Answers: 0

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

Answers

  • allanallan Posts: 54,572Questions: 1Answers: 8,534 Site admin

    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

  • colincolin Posts: 12,479Questions: 0Answers: 2,117

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

    Colin

Sign In or Register to comment.