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

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

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

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

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • 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
    • Showing results for:
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session
    • Close
  • Joseph Fox
    Joseph Fox
    3,648 Points

    Why am I having to set the values like this to display ID 700 - ID 720?

    Posted on Oct 30, 2020 by Joseph Fox
    Joseph Fox
    3,648 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session

    0 Answers

  • Miràs Maulenov
    Miràs Maulenov
    1,787 Points

    How to find missing values in a sequence?

    Posted on Jul 21, 2018 by Miràs Maulenov
    Miràs Maulenov
    1,787 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session

    1 Answer

  • eodell
    eodell
    26,386 Points

    N.B Due to actors being removed from the database the 701st row has the id of 702

    Posted on Oct 5, 2017 by eodell
    eodell
    26,386 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session

    1 Answer

  • Monica Dhulipudi
    Monica Dhulipudi
    4,075 Points

    SELECT *FROM movies ORDER BY DESC; Will this query give me back an output? Is it incomplete statement?

    Posted on Jun 22, 2017 by Monica Dhulipudi
    Monica Dhulipudi
    4,075 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session

    5 Answers

  • Christopher Judas
    Christopher Judas
    5,499 Points

    Is there an efficient way to pull data from multiple tables that are in the same database, in the same query?

    Posted on Jul 19, 2016 by Christopher Judas
    Christopher Judas
    5,499 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Practice Session

    1 Answer

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
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.