Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • Kristina Gillooly
    Kristina Gillooly
    9,546 Points

    Get the 101st to 200th actor from actors table.

    Posted October 2, 2015 5:31pm by Kristina Gillooly
    Kristina Gillooly
    9,546 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Bularca Andrei
    Bularca Andrei
    2,408 Points

    What is the sollution ?

    Posted September 22, 2015 10:58am by Bularca Andrei
    Bularca Andrei
    2,408 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Anders Lund
    Anders Lund
    3,061 Points

    Whats wrong, LIMIT in Databases

    Posted September 20, 2015 11:10am by Anders Lund
    Anders Lund
    3,061 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    0 Answers

  • Cedric Kehi
    Cedric Kehi
    1,078 Points

    Get the 101st to 200th actor from the actors table. (No need to use any ordering).

    Posted September 8, 2015 10:32pm by Cedric Kehi
    Cedric Kehi
    1,078 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    2 Answers

  • Michael King
    Michael King
    874 Points

    Get the 101st to 200th actor from the actors table. SELECT * FROM actors LIMIT 99, 100; Why is this incorrect?

    Posted July 8, 2015 6:26pm by Michael King
    Michael King
    874 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Granit Berisha
    Granit Berisha
    14,150 Points

    Hi there, Can anyone help me with this question: Get the 101st to 200th actor from the actors table.

    Posted June 30, 2015 1:27am by Granit Berisha
    Granit Berisha
    14,150 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    3 Answers

  • Kent Drummond
    Kent Drummond
    8,309 Points

    issues limiting data using limit statement

    Posted June 26, 2015 8:37pm by Kent Drummond
    Kent Drummond
    8,309 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • MUZ140610 Tinashe Marunda
    MUZ140610 Tinashe Marunda
    7,028 Points

    Get the 11th to 30th movie from the movies table. (Again no need to order the results).

    Posted June 18, 2015 11:52pm by MUZ140610 Tinashe Marunda
    MUZ140610 Tinashe Marunda
    7,028 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • MUZ140610 Tinashe Marunda
    MUZ140610 Tinashe Marunda
    7,028 Points

    Get the 11th to 30th movie from the movies table. (Again no need to order the results).

    Posted June 17, 2015 6:26pm by MUZ140610 Tinashe Marunda
    MUZ140610 Tinashe Marunda
    7,028 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Stephen Moss
    Stephen Moss
    2,285 Points

    I've read the documentation and checked against my database and the query is correct, but reporting wrong in the quiz.

    Posted May 31, 2015 2:31am by Stephen Moss
    Stephen Moss
    2,285 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    2 Answers

  • dotz
    dotz
    6,733 Points

    LIMITING

    Posted May 25, 2015 1:53am by dotz
    dotz
    6,733 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Henry Fleisher
    Henry Fleisher
    460 Points

    For Challenge Task 2 of 2, I wrote the following code: "SELECT * FROM movies LIMIT 12, 20." Why is it wrong?

    Posted May 23, 2015 6:54pm by Henry Fleisher
    Henry Fleisher
    460 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    1 Answer

  • Becca Ades
    Becca Ades
    4,205 Points

    I'm putting the following answer "SELECT * FROM actors LIMIT 1. 100;" and I'm getting an error message. Help!

    Posted May 21, 2015 7:16pm by Becca Ades
    Becca Ades
    4,205 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    2 Answers

  • Anthony Perera
    Anthony Perera
    9,185 Points

    The Answers I typed: SELECT * FROM actors LIMIT 100, 99; which is wrong, any suggestions?

    Posted May 1, 2015 12:23pm by Anthony Perera
    Anthony Perera
    9,185 Points
    • Development Tools
    • Database Foundations
    • Reading Data from Databases with SQL
    • Limiting the Result Set

    3 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

  • About
  • Blog
  • Community
  • Stories
  • Contact
  • Gift Card

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord