Treehouse | Community | Review: Ordering, Limiting and Paging Results

✨ 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!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Rosina Marchan
3,011 Points
Back in the teachers notes I included a reference to how other databases LIMIT results.

Posted on Sep 2, 2023 by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Courage Ngonidzaishe Moyosvi
28,998 Points
I would type in at the end of an`ORDER BY` clause to order in ascending order.

Posted on May 16, 2020 by Courage Ngonidzaishe Moyosvi

Courage Ngonidzaishe Moyosvi
28,998 Points
1 Answer
Daniil Kalinkin
853 Points
I would type in ______ at the end of an`ORDER BY` clause to order in descending order. What should I write here?

Posted on Jan 30, 2020 by Daniil Kalinkin

Daniil Kalinkin
853 Points
1 Answer
Grady Robbins
8,249 Points
Reporting with SQL final assesment: i am thrown off by: LIMIT 0, OFFSET 50. should any rows be returned at all?

Posted on Apr 21, 2019 by Grady Robbins

Grady Robbins
8,249 Points
2 Answers
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Retrieving Data - SELECT, LIMIT, OFFSET

Posted on Sep 7, 2018 by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
2 Answers
PLUS

Madhuri Maddala
Courses Plus Student 793 Points
Obtain the actor records between the 701st and 720th records using only LIMIT and OFFSET

Posted on Apr 7, 2017 by Madhuri Maddala

Madhuri Maddala
Courses Plus Student 793 Points
2 Answers

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