Treehouse | Community | Retrieving a Result Set

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

🌟 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

omid nassir
8,771 Points
None of my queries execute

Posted January 31, 2017 8:01am by omid nassir

omid nassir
8,771 Points
1 Answer
Grigorij Schleifer
10,365 Points
Second Task from Limiting Results challenge !

Posted November 2, 2015 7:49am by Grigorij Schleifer

Grigorij Schleifer
10,365 Points
1 Answer
Seth Warner
5,348 Points
OKay so why exactly would you just not use the % right off the bat..also

Posted October 11, 2015 8:51pm by Seth Warner

Seth Warner
5,348 Points
1 Answer
Justin Yu
3,773 Points
this question does not work i put in right answer

Posted October 5, 2015 7:40pm by Justin Yu

Justin Yu
3,773 Points
2 Answers
Kristina Gillooly
9,546 Points
Get the 101st to 200th actor from actors table.

Posted October 2, 2015 5:31pm by Kristina Gillooly

Kristina Gillooly
9,546 Points
1 Answer
Bularca Andrei
2,408 Points
What is the sollution ?

Posted September 22, 2015 10:58am by Bularca Andrei

Bularca Andrei
2,408 Points
1 Answer
Rana Melissa Baghdar
9,425 Points
Cant figure out how to add the treehouse database to mysql

Posted September 20, 2015 4:11pm by Rana Melissa Baghdar

Rana Melissa Baghdar
9,425 Points
1 Answer
Anders Lund
3,061 Points
Whats wrong, LIMIT in Databases

Posted September 20, 2015 11:10am by Anders Lund

Anders Lund
3,061 Points
0 Answers
Cedric Kehi
1,078 Points
Get the 101st to 200th actor from the actors table. (No need to use any ordering).

Posted September 8, 2015 10:32pm by Cedric Kehi

Cedric Kehi
1,078 Points
2 Answers
Philip Bessa
5,396 Points
"Cannot Open Administrator" error?

Posted September 8, 2015 5:21pm by Philip Bessa

Philip Bessa
5,396 Points
0 Answers
Ryan Lail
4,386 Points
In what situation would I use the long form syntax?

Posted August 24, 2015 12:22pm by Ryan Lail

Ryan Lail
4,386 Points
1 Answer
Philip Harper
10,033 Points
Insert values in junction table for many to many relationships (MySQL)?

Posted August 15, 2015 11:22am by Philip Harper

Philip Harper
10,033 Points
1 Answer
Brian Baker
471 Points
Select all movies from between the years 1999 to 2004

Posted August 4, 2015 4:41am by Brian Baker

Brian Baker
471 Points
1 Answer
Hector Urbina
6,064 Points
I can’t start my MySQL Server.

Posted July 30, 2015 5:14pm by Hector Urbina

Hector Urbina
6,064 Points
2 Answers
samilan
408 Points
ORDER BY year and ORDER BY year ASC

Posted July 28, 2015 11:23pm by samilan

samilan
408 Points
1 Answer
samilan
408 Points
Select all movies from the year 2003. my answer is: SELECT * FROM movies WHERE year >= 2003; why it's wrong?

Posted July 26, 2015 11:59pm by samilan

samilan
408 Points
1 Answer
Karolis Strazdas
1,276 Points
SQL Error

Posted July 25, 2015 5:55pm by Karolis Strazdas

Karolis Strazdas
1,276 Points
1 Answer
Daniel Sibanda
4,803 Points
Order "actors" by "name" in reversed alphabetical order

Posted July 22, 2015 1:38pm by Daniel Sibanda

Daniel Sibanda
4,803 Points
1 Answer
Daniel Sibanda
4,803 Points
select query

Posted July 22, 2015 10:55am by Daniel Sibanda

Daniel Sibanda
4,803 Points
0 Answers
Eirin Joahna Pamela Gonzales
8,686 Points
Using WHERE keyword to select data

Posted July 17, 2015 4:00am by Eirin Joahna Pamela Gonzales

Eirin Joahna Pamela Gonzales
8,686 Points
2 Answers
muz141018susanmusonza
3,695 Points
help me

Posted July 14, 2015 12:50pm by muz141018susanmusonza

muz141018susanmusonza
3,695 Points
1 Answer
muz141018susanmusonza
3,695 Points
help me guys am stuck

Posted July 14, 2015 11:02am by muz141018susanmusonza

muz141018susanmusonza
3,695 Points
1 Answer
MUZ140683 Viniel Munjeri
3,448 Points
Write a SELECT statement that retrieves only the "title" from the "movies" table

Posted July 14, 2015 1:46am by MUZ140683 Viniel Munjeri

MUZ140683 Viniel Munjeri
3,448 Points
1 Answer
Michael King
874 Points
Get the 101st to 200th actor from the actors table. SELECT * FROM actors LIMIT 99, 100; Why is this incorrect?

Posted July 8, 2015 6:26pm by Michael King

Michael King
874 Points
1 Answer
Granit Berisha
14,150 Points
Hi there, Can anyone help me with this question: Get the 101st to 200th actor from the actors table.

Posted June 30, 2015 1:27am by Granit Berisha

Granit Berisha
14,150 Points
3 Answers
Kent Drummond
8,309 Points
issues limiting data using limit statement

Posted June 26, 2015 8:37pm by Kent Drummond

Kent Drummond
8,309 Points
1 Answer
MUZ140610 Tinashe Marunda
7,028 Points
Get the 11th to 30th movie from the movies table. (Again no need to order the results).

Posted June 18, 2015 11:52pm by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
1 Answer
MUZ140610 Tinashe Marunda
7,028 Points
Get the 11th to 30th movie from the movies table. (Again no need to order the results).

Posted June 17, 2015 6:26pm by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
1 Answer
MUZ140610 Tinashe Marunda
7,028 Points
Help me out guys

Posted June 15, 2015 11:49am by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
0 Answers
MUZ140610 Tinashe Marunda
7,028 Points
help

Posted June 8, 2015 12:49pm by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
1 Answer

Prev Page 1 of 2 Next

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