Treehouse | Community | Limiting the Result Set

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
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
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
Stephen Moss
2,285 Points
I've read the documentation and checked against my database and the query is correct, but reporting wrong in the quiz.

Posted May 31, 2015 2:31am by Stephen Moss

Stephen Moss
2,285 Points
2 Answers
dotz
6,733 Points
LIMITING

Posted May 25, 2015 1:53am by dotz

dotz
6,733 Points
1 Answer
Henry Fleisher
460 Points
For Challenge Task 2 of 2, I wrote the following code: "SELECT * FROM movies LIMIT 12, 20." Why is it wrong?

Posted May 23, 2015 6:54pm by Henry Fleisher

Henry Fleisher
460 Points
1 Answer
Becca Ades
4,205 Points
I'm putting the following answer "SELECT * FROM actors LIMIT 1. 100;" and I'm getting an error message. Help!

Posted May 21, 2015 7:16pm by Becca Ades

Becca Ades
4,205 Points
2 Answers
Anthony Perera
9,185 Points
The Answers I typed: SELECT * FROM actors LIMIT 100, 99; which is wrong, any suggestions?

Posted May 1, 2015 12:23pm by Anthony Perera

Anthony Perera
9,185 Points
3 Answers

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

Kristina Gillooly

Kristina Gillooly

Bularca Andrei

Bularca Andrei

Anders Lund

Anders Lund

Cedric Kehi

Cedric Kehi

Michael King

Michael King

Granit Berisha

Granit Berisha

Kent Drummond

Kent Drummond

MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda

Stephen Moss

Stephen Moss

dotz

dotz

Henry Fleisher

Henry Fleisher

Becca Ades

Becca Ades

Anthony Perera

Anthony Perera