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

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

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 September 2, 2023 2:12pm 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 May 16, 2020 9:31pm 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 January 30, 2020 12:24am 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 April 21, 2019 5:23pm 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 September 7, 2018 7:20pm 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 April 7, 2017 4:43am 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.