I have records that have a unique ID but may share a value EVENT_ID. When using the SELECT statement, I need to show ONLY THE FIRST record of EACH EVENT_ID. What would be the most efficient query to use for this?
Thank you for any help.
I think if you go to mysql.com and search for UNIQUE... that command may solve your problem
