Treehouse | Community | Limiting Results

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

Join our free workshop and get a Treehouse discount code! 💼 Register here!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
Alexander Vasin
7,938 Points
Bummer: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001". Looks like the same

Posted July 17, 2020 4:53pm by Alexander Vasin

Alexander Vasin
7,938 Points
1 Answer
sherelle smith
1,387 Points
"Was expecting 11 entries in the users table. There's only 10" error?

Posted July 11, 2020 4:18am by sherelle smith

sherelle smith
1,387 Points
3 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
Jorgen Rasmussen
3,367 Points
Loans,books and patrons question

Posted July 8, 2020 7:02pm by Jorgen Rasmussen

Jorgen Rasmussen
3,367 Points
- Databases
0 Answers
Timmy Welch
1,599 Points
Getting same result as expected but not being allowed past the question.

Posted July 4, 2020 3:27pm by Timmy Welch

Timmy Welch
1,599 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I don't understand where I should SELECT a new column and where I should concatenate the new output

Posted July 4, 2020 9:39am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
1 Answer
Benjamin Hanley
3,410 Points
SQL Error: near "Car": syntax error

Posted July 2, 2020 2:34pm by Benjamin Hanley

Benjamin Hanley
3,410 Points
2 Answers
Tom Holliday
2,868 Points
I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

Posted July 1, 2020 1:36pm by Tom Holliday

Tom Holliday
2,868 Points
1 Answer
Ariadna Rodriguez
6,281 Points
should both columns be a substrings?

Posted July 1, 2020 4:14am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Ariadna Rodriguez
6,281 Points
Should I be adding a space in between the commas also is that why my query is incorrect?

Posted June 29, 2020 1:03am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Philip Porwisch
13,229 Points
Query not returning correct total

Posted June 27, 2020 6:20pm by Philip Porwisch

Philip Porwisch
13,229 Points
1 Answer
Mohamed Elauzei
2,191 Points
Insert Statement Challenge

Posted June 27, 2020 4:44pm by Mohamed Elauzei

Mohamed Elauzei
2,191 Points
1 Answer
William Ray Noble
22,190 Points
What is "If__name__ =__main__"?

Posted June 18, 2020 12:14am by William Ray Noble

William Ray Noble
22,190 Points
- Databases
1 Answer
Milind Sharma
2,656 Points
Why am i getting extra . at the end the select statement?

Posted June 17, 2020 4:40pm by Milind Sharma

Milind Sharma
2,656 Points
1 Answer
Elias Starks
Full Stack JavaScript Techdegree Graduate 13,605 Points
ERROR with npm install --save sqlite3

Posted June 15, 2020 3:41am by Elias Starks

Elias Starks
Full Stack JavaScript Techdegree Graduate 13,605 Points
- Databases
0 Answers
Mostafa Alhosain
7,305 Points
Hey, I have a question regarding databases especially MySQL.

Posted June 6, 2020 8:32am by Mostafa Alhosain

Mostafa Alhosain
7,305 Points
- Databases
1 Answer
Michael Trilford
182 Points
What is the best course to learn about data on the web?

Posted May 30, 2020 2:35am by Michael Trilford

Michael Trilford
182 Points
- Databases
1 Answer
Joe Li
3,234 Points
What column am I missing from my query?

Posted May 28, 2020 4:34pm by Joe Li

Joe Li
3,234 Points
2 Answers
Derek Morse
1,776 Points
stuck

Posted May 27, 2020 3:04pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Tadjiev Codes
9,626 Points
Inner Join and Self Join explanation

Posted May 27, 2020 5:37am by Tadjiev Codes

Tadjiev Codes
9,626 Points
- Databases
1 Answer
Derek Morse
1,776 Points
NOT understanding

Posted May 26, 2020 6:39pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
help with details; please break down what i am missing

Posted May 26, 2020 2:30pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
STUCK AGAIN

Posted May 26, 2020 2:25pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
STILL STUCK

Posted May 26, 2020 2:21pm by Derek Morse

Derek Morse
1,776 Points
0 Answers
Tadjiev Codes
9,626 Points
What's wrong with my version?

Posted May 26, 2020 11:30am by Tadjiev Codes

Tadjiev Codes
9,626 Points
4 Answers
Richard Chintembo
5,400 Points
In the Yorkshire Division Four in Rugby, the team Hessle RUFC have a website that shows their latest matches. Their data

Posted May 23, 2020 2:21pm by Richard Chintembo

Richard Chintembo
5,400 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
Tremayne Moncrief
2,380 Points
I can not figure out why I can not get the correct answer for Challenge Task 2 updating tables

Posted May 21, 2020 7:01pm by Tremayne Moncrief

Tremayne Moncrief
2,380 Points
1 Answer

Prev Page 14 of 389 Next

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