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

Alexandra Washick
6,649 Points
WHERE clause and ORDER BY?

Posted October 24, 2024 4:42pm by Alexandra Washick

Alexandra Washick
6,649 Points
2 Answers
Rachel Waybill
1,393 Points
I don't understand what this is supposed to be.

Posted July 30, 2024 7:11pm by Rachel Waybill

Rachel Waybill
1,393 Points
1 Answer
Rachel Waybill
1,393 Points
This is backward - it hasn't shown me how to do this yet but it is supposed to in the next section

Posted July 30, 2024 12:15am by Rachel Waybill

Rachel Waybill
1,393 Points
1 Answer
Laura Dumitru
9,818 Points
DOESNT WORK: SELECT title LENGTH(title) AS longest_length FROM books ORDER BY longest_length DESC LIMIT 1;

Posted July 10, 2024 2:10pm by Laura Dumitru

Laura Dumitru
9,818 Points
1 Answer
Nile Rankin-Watson
1,780 Points
What's wrong with this code? SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field";

Posted June 18, 2024 8:28pm by Nile Rankin-Watson

Nile Rankin-Watson
1,780 Points
1 Answer
Abigail Solomon
Data Analysis Techdegree Student 4,203 Points
How do you alias the strings you concatenate to "to_field"? And properly concatenate these strings?

Posted May 10, 2024 8:33pm by Abigail Solomon

Abigail Solomon
Data Analysis Techdegree Student 4,203 Points
2 Answers
Grace BakerWhitcomb
1,296 Points
Help with query please

Posted February 28, 2024 4:50am by Grace BakerWhitcomb

Grace BakerWhitcomb
1,296 Points
2 Answers
Jennifer Sanders
1,747 Points
Help with code, please.

Posted December 13, 2023 7:39pm by Jennifer Sanders

Jennifer Sanders
1,747 Points
1 Answer
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
Juan Moyar
2,871 Points
Result form Task 1

Posted August 4, 2023 3:42pm by Juan Moyar

Juan Moyar
2,871 Points
2 Answers
ashwathh
3,129 Points
how to format date in mm/yyyy format in SQL?

Posted June 27, 2023 12:10am by ashwathh

ashwathh
3,129 Points
1 Answer
Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted April 30, 2023 10:44pm by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted April 26, 2023 12:15pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
IN a library database....

Posted April 24, 2023 4:23pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Wufei Hong
1,393 Points
bummer reason

Posted March 24, 2023 6:08am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Krithika Pirahalathan
150 Points
alias the query

Posted March 8, 2023 1:25pm by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
1 Answer
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
Alberto Gurrola
1,769 Points
Hi, I'm not too sure what I'm doing wrong. I tried entering this code but it's still wrong.

Posted February 22, 2023 2:36pm by Alberto Gurrola

Alberto Gurrola
1,769 Points
1 Answer
Minh Duong
1,616 Points
SELECT CONCAT(first_name, ' ', last_name) AS "To_field", CONCAT('<', email, '>') AS "To" FROM patrons; why is missing?

Posted February 9, 2023 8:43pm by Minh Duong

Minh Duong
1,616 Points
1 Answer
Brian Taylor
3,436 Points
Your code challenge appears to have a broken Javascript file in it? (or at least in this instance of the virtual machine

Posted January 26, 2023 6:57am by Brian Taylor

Brian Taylor
3,436 Points
1 Answer
Miroslav Pasajlic
795 Points
Question Expecting results like 'L Chalkley' not 'L Chalkley'

Posted December 23, 2022 6:01pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
2 Answers
Miroslav Pasajlic
795 Points
Question Bummer: You're missing the angle brackets around the email address.

Posted December 23, 2022 3:48pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
1 Answer
Nelson Hinman Jr
7,078 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,078 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
Spencer Lebel
3,125 Points
Need helping finding the Count of ordered_on today.

Posted October 18, 2022 10:44pm by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Cristian Luca
4,102 Points
What's wrong with my code? Thanks a lot!

Posted October 17, 2022 6:34pm by Cristian Luca

Cristian Luca
4,102 Points
3 Answers
MARSHA OURSO
4,312 Points
SUBSTR

Posted October 10, 2022 2:06pm by MARSHA OURSO

MARSHA OURSO
4,312 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Help With Reporting WITH SQL

Posted September 30, 2022 2:26pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Need help with this SQL query

Posted September 20, 2022 2:41pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer

Prev Page 1 of 18 Next

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