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

Our end of year sale ends soon 👀 Get a year of Courses for $150 (40% off!)

Jump into new course Python Dates and Times 🐍

Learn React with us!

Dive into new course Game Development with Phaser 👾

💥 ALL NEW: Code Adventures! ⚡ Dare to embark on a front end coding adventure 🌟

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

🤖 Check out all our AI content here 👀

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

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

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
Jason Chalangary
11,695 Points
What is wrong with my code?

Posted August 15, 2023 1:21pm by Jason Chalangary

Jason Chalangary
11,695 Points
2 Answers
Krithika Pirahalathan
150 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted March 8, 2023 11:10am by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
0 Answers
Nelson Hinman Jr
7,077 Points
Problem with SQL Reporting Task #2 - finding the oldest Science Fiction book

Posted November 22, 2022 2:44am by Nelson Hinman Jr

Nelson Hinman Jr
7,077 Points
2 Answers
AJ Ramirez
5,403 Points
Cannot complete the answer to the question

Posted October 29, 2022 9:39am by AJ Ramirez

AJ Ramirez
5,403 Points
2 Answers
James Silvester
4,511 Points
Why doesn't this work?

Posted March 21, 2022 7:11pm by James Silvester

James Silvester
4,511 Points
2 Answers
jaxne
11,575 Points
SELECT * FROM books WHERE genre LIKE Fantasy ORDER BY first_published LIMIT 5 ASC

Posted September 19, 2021 2:26am by jaxne

jaxne
11,575 Points
2 Answers
Uzair Khan
1,763 Points
I am unsure with this query

Posted January 31, 2021 1:37pm by Uzair Khan

Uzair Khan
1,763 Points
1 Answer
Samuel Lawal
2,845 Points
Reporting with SQL question

Posted January 19, 2021 10:55pm by Samuel Lawal

Samuel Lawal
2,845 Points
1 Answer
Joseph Fox
3,648 Points
Why am I having to set the values like this to display ID 700 - ID 720?

Posted October 30, 2020 8:42pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Jenn Giulietti
4,888 Points
SQL limiting difficulty

Posted October 27, 2020 12:52am by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
Can't figure it out

Posted October 25, 2020 12:58am by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
4 Answers
aditya verma
1,853 Points
Mistake in code

Posted August 2, 2020 5:58am by aditya verma

aditya verma
1,853 Points
1 Answer
sherelle smith
1,387 Points
SELECT * FROM books WHERE genre LIKE "%Fantasy" ORDER BY first_published LIMIT 5 ASC;

Posted July 19, 2020 5:57pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
PLUS

mohammad almotairy
Courses Plus Student 606 Points
I did not understand the question Write the SQL query to retrieve the 3rd page of results

Posted July 9, 2020 12:23pm by mohammad almotairy

mohammad almotairy
Courses Plus Student 606 Points
1 Answer
montrellstory
Full Stack JavaScript Techdegree Student 11,145 Points
I don't see it

Posted May 23, 2020 2:46am by montrellstory

montrellstory
Full Stack JavaScript Techdegree Student 11,145 Points
2 Answers
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
Stacy Villibord
2,017 Points
Correct my syntax

Posted April 22, 2020 3:32am by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
Caleb Newell
12,562 Points
SQL limit

Posted March 11, 2020 1:56pm by Caleb Newell

Caleb Newell
12,562 Points
3 Answers
Kalif Yusuf
4,056 Points
Not sure, what is wrong with the away I answered the question

Posted February 29, 2020 7:04pm by Kalif Yusuf

Kalif Yusuf
4,056 Points
1 Answer
Mayo Toyota
2,121 Points
genre = "Science Fiction"

Posted February 15, 2020 9:17pm by Mayo Toyota

Mayo Toyota
2,121 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
Fredrick Adegoke
1,983 Points
Unsure why my query is failing

Posted December 11, 2019 10:28am by Fredrick Adegoke

Fredrick Adegoke
1,983 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers
sevdiye ozlutas
1,453 Points
I am struggling to write a query for this question. What is should be?

Posted August 26, 2019 11:09am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Yung Kazi
6,997 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,997 Points
2 Answers
Adam Tyler
14,865 Points
Why does this need a WHERE clause?

Posted June 19, 2019 4:02pm by Adam Tyler

Adam Tyler
14,865 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
Karl Hogben
462 Points
> SELECT * FROM books WHERE genre = "Fantasy" ORDER BY genre ASC LIMIT 5

Posted April 14, 2019 4:33pm by Karl Hogben

Karl Hogben
462 Points
1 Answer

Prev Page 1 of 3 Next

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