Treehouse | Community | Review: Ordering, Limiting and Paging Results

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ 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

Grady Robbins
8,249 Points
Reporting with SQL final assesment: i am thrown off by: LIMIT 0, OFFSET 50. should any rows be returned at all?

Posted April 21, 2019 5:23pm by Grady Robbins

Grady Robbins
8,249 Points
2 Answers
sofia Heikkila Svensson
3,695 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
3,695 Points
1 Answer
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
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Robert Hecht
6,797 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
6,797 Points
1 Answer
David Wells
13,270 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
13,270 Points
2 Answers
Ker Sing Tan
10,573 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
10,573 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
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Satyam garhewal
326 Points
Why my query is not working, can you please help me out?

Posted March 1, 2019 5:46am by Satyam garhewal

Satyam garhewal
326 Points
2 Answers
Øystein Kallset
11,044 Points
What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Posted February 28, 2019 7:43am by Øystein Kallset

Øystein Kallset
11,044 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 4:03pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 12:59am by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
4,660 Points
2 Answers
Dan Epstein
3,233 Points
Can anyone assist with how to order the statement in the first SQL Concatenation code challenge? I kind of got lost.

Posted February 14, 2019 10:07am by Dan Epstein

Dan Epstein
3,233 Points
6 Answers
william gallagher
1,919 Points
What is wrong with my code?

Posted February 11, 2019 1:43am by william gallagher

william gallagher
1,919 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
Iman Ali
3,460 Points
ERROR WHEN CONCATENATING WITH A COMMA

Posted February 10, 2019 1:46pm by Iman Ali

Iman Ali
3,460 Points
2 Answers
Andrzej Szelemetko
25,447 Points
replace(email, '@', '<at>') problems in task I am getting the following error: Bummer: Expectin

Posted February 3, 2019 7:31pm by Andrzej Szelemetko

Andrzej Szelemetko
25,447 Points
1 Answer
Harris Handoko
3,932 Points
Why is the WHERE clause required here instead of the HAVING clause?

Posted February 1, 2019 2:24am by Harris Handoko

Harris Handoko
3,932 Points
1 Answer
Michael Nanni
7,358 Points
What exactly am I counting?

Posted January 29, 2019 1:29pm by Michael Nanni

Michael Nanni
7,358 Points
1 Answer
Jeremy Jones
886 Points
Unclear what the desired answer is, again

Posted January 28, 2019 8:44pm by Jeremy Jones

Jeremy Jones
886 Points
1 Answer
vishal mishra
387 Points
select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

Posted January 26, 2019 2:38pm by vishal mishra

vishal mishra
387 Points
1 Answer
Jeremy Jones
886 Points
Unclear what I am getting wrong...

Posted January 24, 2019 5:19pm by Jeremy Jones

Jeremy Jones
886 Points
2 Answers

Prev Page 10 of 18 Next

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