Check out a free preview of the full SQL Fundamentals course:
The "LIMITing and ORDERing the result set" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
Mike illustrates that when working with large collections of data, it is essential to be able to sort data as well as paginate or scroll through the results. Mike demonstrates how to do this with LIMIT and OFFSET to retrieve the records of interest, and ORDER BY to sort.