Menu

Tech

English

Limit number of records

Part of the Fundamentals section of Coddy's SQL journey — lesson 16 of 72.

Let's assume we fetched a lot of data. Sometimes we only need the top 5 or the top 10 records.

To limit the number of records we can use the LIMIT keyword

For example

SELECT *
FROM table1
LIMIT 10

This will return the top 10 records.

Challenge

Easy

Available tables and columns:

<strong>temperature</strong>: <strong>place_id</strong>, <strong>avg_temp</strong>

Fetch the 5 coldest places from the temperature table. Follow these steps:

Sort the result in ascending order
Limit the result to 5 rows

Cheat sheet

To limit the number of records returned by a query, use the LIMIT keyword:

SELECT *
FROM table1
LIMIT 10

This returns the top 10 records from the table.

Try it yourself

Test yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

All lessons in Fundamentals

3Specific Return Format

Null values Sort Results Part 1 Sort Results Part 2 Recap - Cyber Security FirmLimit number of recordsRecap - Vehicle Factory

6Intro Challenges

Recap - Parliamentary Election Recap - Police Criminal Arrest Recap - Bar Beverage Container Recap - Engineer new columns

9Multiple tables

Basic Join Part 1 Basic Join Part 2 Recap - Join Self join Recap - Self Join Union Simplify queries, WITH keyword Recap - With Queries Recap - Real Estate Contractor

12Window Functions part 2

RANK & DENSE_RANK Functions Recap - RANK & DENSE_RANK NTILE Function Aggregation Functions ROWS & RANGE Criterion