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

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

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.