Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
20. Second Fastest Time in Races (Medium)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible