15 Oct 2021 Kateryna Koidan How to Join Only the First Row in SQL In your projects, you may encounter situations when you have many orders corresponding to one customer or many temperature observations corresponding to the same location, but you only need to join the first row with the most recent order or the most recently observed temperature to the corresponding record in another table. In this article, I’ll go through several ways to do this in SQL. The best way to practice basic and advanced SQL is our interactive SQL Practice Set course. Read more