Assistance with the DISTINCT keyword

[email protected]
Newsgroups gmane.comp.php.general
Message-ID <CACOt7mGi9neHtLpmMAT=cGickDCqPR=RS3SkQ-zv6244J5X__w@mail.gmail.com>
Hello. I'm wondering if I can get assistance with the DISTINCT keyword?

I've got a Table with 5-6 fields/information but 1000+ records. I want to
select all fields but only use DISTINCT on one specific field.

There may be 1, 2, or 10+ records with a distinct code - I only want to
choose the oldest record of each distinct code, but 5 unique/distinct
records.

PROBLEM:  https://www.mysqltutorial.org/mysql-distinct.aspx

If I select multiple records, SELECT DISTINCT field1, Field2, etc..  it
seems to combine "Field1, Field2" into one field and make a DISTINCT on
THAT information, instead of just field1.

In all the tutorials I find I can only retrieve ONE field/information using
DISTINCT, without retrieving all the information/fields.

Is it possible to select distinct on 1field, but retrieve ALL fields for
that record?


An example of what I want:  Select DISTINCT REF, * from Services ORDER BY
`Services`.`TIMECHECK` ASC LIMIT 5;

*TIMECHECK* is a simple timestamp


Or do I need to do this in a 2-step process?
- get 5 records  Distinct on the REF, sort by oldest records
- select all fields/columns of information for each unique record,
(HOWEVER, I only want the oldest record).
-- 

Gordon.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.