MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE JLSSWIMMING1 (
  id INT UNSIGNED PRIMARY KEY,
  Name VARCHAR(5) NOT NULL,
  Year TINYINT UNSIGNED NOT NULL,
  Stroke ENUM('Freestyle', 'Backstroke', 'Breaststroke', 'Front-Crawl') NOT NULL,
  Dist TINYINT UNSIGNED NOT NULL,
  Time DECIMAL(5, 2) NOT NULL
);
INSERT INTO JLSSWIMMING1 VALUES
  ( 1, 'Name1', 7, 'Freestyle'   , 25, 10),
  ( 2, 'Name2', 7, 'Freestyle'   , 25, 11),
  ( 3, 'Name3', 7, 'Freestyle'   , 25, 12),
  ( 4, 'Name1', 7, 'Freestyle'   , 50, 23),
  ( 5, 'Name2', 7, 'Freestyle'   , 50, 25),
  ( 6, 'Name3', 7, 'Freestyle'   , 50, 27),
  ( 7, 'Name1', 7, 'Backstroke'  , 25, 12),
  ( 8, 'Name2', 7, 'Backstroke'  , 25, 10),
  ( 9, 'Name3', 7, 'Backstroke'  , 25, 11),
  (10, 'Name1', 7, 'Breaststroke', 25, 12),
  (11, 'Name2', 7, 'Breaststroke', 25, 11),
  (12, 'Name3', 7, 'Breaststroke', 25, 10),
  (13, 'Name1', 7, 'Front-Crawl' , 25, 10),
  (14, 'Name2', 7, 'Front-Crawl' , 25, 12),
  (15, 'Name3', 7, 'Front-Crawl' , 25, 10);

Records: 15  Duplicates: 0  Warnings: 0


SELECT * FROM JLSSWIMMING1;


id
Name
Year
Stroke
Dist
Time


1
Name1
7
Freestyle
25
10.00

2
Name2
7
Freestyle
25
11.00

3
Name3
7
Freestyle
25
12.00

4
Name1
7
Freestyle
50
23.00

5
Name2
7
Freestyle
50
25.00

6
Name3
7
Freestyle
50
27.00

7
Name1
7
Backstroke
25
12.00

8
Name2
7
Backstroke
25
10.00

9
Name3
7
Backstroke
25
11.00

10
Name1
7
Breaststroke
25
12.00

11
Name2
7
Breaststroke
25
11.00

12
Name3
7
Breaststroke
25
10.00

13
Name1
7
Front-Crawl
25
10.00

14
Name2
7
Front-Crawl
25
12.00

15
Name3
7
Front-Crawl
25
10.00


/* Notice this returns two rows for "Front-Crawl" due to the tie */
SELECT *
FROM JLSSWIMMING1
WHERE (Year, Stroke, Dist, Time) IN (
    SELECT Year, Stroke, Dist, MIN(Time)
    FROM JLSSWIMMING1
    WHERE Year = 7
    GROUP BY Stroke, Dist
);


id
Name
Year
Stroke
Dist
Time


1
Name1
7
Freestyle
25
10.00

4
Name1
7
Freestyle
50
23.00

8
Name2
7
Backstroke
25
10.00

12
Name3
7
Breaststroke
25
10.00

13
Name1
7
Front-Crawl
25
10.00

15
Name3
7
Front-Crawl
25
10.00


SELECT *
FROM (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY Stroke, Dist ORDER BY Time) AS rn
    FROM JLSSWIMMING1
    WHERE Year = 7
) AS tmp
WHERE rn = 1;


id
Name
Year
Stroke
Dist
Time
rn


1
Name1
7
Freestyle
25
10.00
1

4
Name1
7
Freestyle
50
23.00
1

8
Name2
7
Backstroke
25
10.00
1

12
Name3
7
Breaststroke
25
10.00
1

13
Name1
7
Front-Crawl
25
10.00
1

id	Name	Year	Stroke	Dist	Time
1	Name1	7	Freestyle	25	10.00
2	Name2	7	Freestyle	25	11.00
3	Name3	7	Freestyle	25	12.00
4	Name1	7	Freestyle	50	23.00
5	Name2	7	Freestyle	50	25.00
6	Name3	7	Freestyle	50	27.00
7	Name1	7	Backstroke	25	12.00
8	Name2	7	Backstroke	25	10.00
9	Name3	7	Backstroke	25	11.00
10	Name1	7	Breaststroke	25	12.00
11	Name2	7	Breaststroke	25	11.00
12	Name3	7	Breaststroke	25	10.00
13	Name1	7	Front-Crawl	25	10.00
14	Name2	7	Front-Crawl	25	12.00
15	Name3	7	Front-Crawl	25	10.00