Treehouse | Community | Limiting 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

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
sj sh
122 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted April 11, 2019 8:37am by sj sh

sj sh
122 Points
0 Answers
Marat Guysin
1,601 Points
Cannot get the right SQL statement

Posted April 6, 2019 11:28pm by Marat Guysin

Marat Guysin
1,601 Points
1 Answer
sulaiman abouabdah
5,314 Points
Error when inserting my own table on my command line message ERROR 1064 (42000): You have an error in your SQL syntax;

Posted March 12, 2019 9:15pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
1 Answer
Dinesh Dewnarain
1,089 Points
Limit rows

Posted February 10, 2019 4:12pm by Dinesh Dewnarain

Dinesh Dewnarain
1,089 Points
1 Answer
Mark Chesney
11,747 Points
link in GitHub not working; please help

Posted January 11, 2019 12:34am by Mark Chesney

Mark Chesney
11,747 Points
1 Answer
Alejandro Carvajal
9,100 Points
Question not written correctly

Posted January 8, 2019 6:45pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Alejandro Carvajal
9,100 Points
Why would a WHERE clause be necessary if I could just return the asked-for information by just ordering with ORDER BY???

Posted January 8, 2019 6:33pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
what is wrong with my query?

Posted December 22, 2018 5:14am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer
kekai borah
855 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted December 7, 2018 6:15am by kekai borah

kekai borah
855 Points
2 Answers
Dilip Kalidindi
1,042 Points
SQL Help

Posted December 5, 2018 3:51am by Dilip Kalidindi

Dilip Kalidindi
1,042 Points
3 Answers
Shahrukh Azhar Khan
2,135 Points
I am having problems writing the code for this challenge. Can someone please help me! Thanks

Posted November 12, 2018 11:06pm by Shahrukh Azhar Khan

Shahrukh Azhar Khan
2,135 Points
2 Answers
Rhea Khanna
2,838 Points
Paging through results

Posted October 19, 2018 5:43pm by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
Rhea Khanna
2,838 Points
Paging with SQL, Limit/ Offset

Posted October 18, 2018 11:30am by Rhea Khanna

Rhea Khanna
2,838 Points
3 Answers
Rhea Khanna
2,838 Points
Limiting data with SQL

Posted October 18, 2018 11:27am by Rhea Khanna

Rhea Khanna
2,838 Points
2 Answers
Sandeep Padda
2,781 Points
Help with this question?

Posted October 16, 2018 12:53am by Sandeep Padda

Sandeep Padda
2,781 Points
1 Answer
Loy Yee Ko
5,814 Points
SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; fail to return any result

Posted October 13, 2018 4:47pm by Loy Yee Ko

Loy Yee Ko
5,814 Points
1 Answer
Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
SQL Query ?

Posted October 6, 2018 11:01pm by Raymond Moore

Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
1 Answer
Shain Jones
1,315 Points
Unsure how to fix the code as the ORDERED BY is there. How can I fix this? Thanks in advance.

Posted October 5, 2018 8:00pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Karen Shumate
13,579 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
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

ct7
Courses Plus Student 964 Points
Challenge task 1 of 2

Posted September 1, 2018 7:29pm by ct7

ct7
Courses Plus Student 964 Points
2 Answers
jon snow
1,774 Points
which database treehouse playground uses?

Posted August 26, 2018 1:18am by jon snow

jon snow
1,774 Points
2 Answers
Amy Hsieh
6,023 Points
Q: The page can display 20 entries, I am asked to display the 3rd page of results.

Posted August 12, 2018 7:21am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer
Hasan Ali
2,039 Points
Not understanding what the question is asking

Posted August 8, 2018 12:34am by Hasan Ali

Hasan Ali
2,039 Points
1 Answer
Miràs Maulenov
1,787 Points
How to find missing values in a sequence?

Posted July 21, 2018 11:15am by Miràs Maulenov

Miràs Maulenov
1,787 Points
1 Answer
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
SQL Challenge task issue

Posted July 16, 2018 10:33am by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
3 Answers
Walter Guerrero
6,843 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted June 7, 2018 11:41am by Walter Guerrero

Walter Guerrero
6,843 Points
1 Answer
Fathima Fas-ha
6,847 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,847 Points
1 Answer
nfs
35,526 Points
I don't understand one thing... What do we mean by "Other Databases" ???

Posted December 17, 2017 11:43am by nfs

nfs
35,526 Points
6 Answers

Prev Page 2 of 3 Next

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