Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
20. Second Fastest Time in Races (Medium)
On this page

Problem Statement

Table: RaceResults
Each row in this table records the time achieved by a participant in a sprint race, including their unique ID and the time they recorded.

+-------------+------+
| Column Name | Type |
+-------------+------+
| id          | int  |
| time        | int  |
+-------------+------+
id is the primary key for this table.
time is recorded in seconds and represents the performance of a participant in a race.

Develop a solution to find the second fastest time (or second smallest time) in the RaceResults table

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page