How to only show unique records

How to only show unique records

lintu98lintu98 Posts: 11Questions: 4Answers: 0


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':

John Doe Active
Jane Doe Inactive
John Doe Active
James Baker Active
Jane Doe Inactive

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



  • 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?


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

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


Sign In or Register to comment.