1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

Exercise

LIMITing your search

You may find yourself working with tables that contain so many records that simple queries can take forever to load. This is especially challenging when you're searching for the right table to use and just need a quick result. For these scenarios the trick is to LIMIT the number of rows that your query returns. In this exercise you will practice using this function.

Instructions 1/2

undefined XP
    1
    2
  • Use LIMIT to return all columns for the first 10 rows for the payment table.