SQL Fundamentals

SQL Fundamentals LIMIT and ORDER Exercise

This course has been updated! We now recommend you take the Complete Intro to SQL & PostgreSQL course.

Check out a free preview of the full SQL Fundamentals course:
The "LIMIT and ORDER Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

In the example app, the orders page has over 16,000 records. This large amount of data is too much data to show to users all at once. Even looking at an individual customer’s orders is a bit overwhelming. In this exercise, students use the existing user interface for sorting and pagination, and modify the “orders list” and “customer orders list” queries as appropriate.

Get Unlimited Access Now