1.4. Limiting Results

Try these first

1. 1.

   What is the purpose of the LIMIT clause in SQL?

   Hint

   Consider why we might not want all rows returned.

2. 2.

   Write a SQL query to select 3 records from a table named 'products'.

   Hint

   Remember the basic syntax for limiting results.

3. 3.

   What does the LIMIT clause do in SQL?

   • Restricts the number of records returned
   • Sorts data in ascending order
   • Combines multiple tables

   Hint

   Think about its purpose when looking at large datasets.

4. 4.

   True or False: The LIMIT clause can specify the exact rows to return such as OFFSET 5, LIMIT 10.

   • True
   • False

   Hint

   Consider how pagination works in data display.

5. 5.

   How would you write a SQL query to find the 7 highest-paid employees from the 'employees' table?

   Hint

   Think about how to sort the records before limiting them.

6. 6.

   Create a query that returns every second record from the 'transactions' table, starting from record 10.

   Hint

   Use both LIMIT and OFFSET effectively.