Learn about our new Community Discord server here and join us on Discord here!

Jump into our new React Basics course 😎

Get job-ready with our Career Toolbox Track's career advice, resume tips, and more 🧰

Probe The AI Multiverse: Exploring the Subfields of Artificial Intelligence 😮

Students: got a cool project or resource to share? Submit it to Treehouse Links! 🤩

Learn about our new Community Discord server here and join us on Discord here!

🤖 Check out all our AI content here 👀

  • Home
  • Free Trial
  • Sign In
  • Plans
  • Tracks
  • Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • AI
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
  • 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.

    Treehouse

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

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Perks
  • Public Library Access
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2023 Treehouse Island, Inc.