Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

James Silvester
4,511 Points
Why doesn't this work?

Posted March 21, 2022 7:11pm by James Silvester

James Silvester
4,511 Points
2 Answers
rjax678
10,242 Points
SELECT * FROM books WHERE genre LIKE Fantasy ORDER BY first_published LIMIT 5 ASC

Posted September 19, 2021 2:26am by rjax678

rjax678
10,242 Points
2 Answers
Uzair Khan
1,763 Points
I am unsure with this query

Posted January 31, 2021 1:37pm by Uzair Khan

Uzair Khan
1,763 Points
1 Answer
Samuel Lawal
2,845 Points
Reporting with SQL question

Posted January 19, 2021 10:55pm by Samuel Lawal

Samuel Lawal
2,845 Points
1 Answer
Joseph Fox
3,648 Points
Why am I having to set the values like this to display ID 700 - ID 720?

Posted October 30, 2020 8:42pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Jenn Giulietti
4,888 Points
SQL limiting difficulty

Posted October 27, 2020 12:52am by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
Can't figure it out

Posted October 25, 2020 12:58am by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
4 Answers
aditya verma
1,853 Points
Mistake in code

Posted August 2, 2020 5:58am by aditya verma

aditya verma
1,853 Points
1 Answer
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
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
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
Courage Ngonidzaishe Moyosvi
28,974 Points
I would type in at the end of an`ORDER BY` clause to order in ascending order.

Posted May 16, 2020 9:31pm by Courage Ngonidzaishe Moyosvi

Courage Ngonidzaishe Moyosvi
28,974 Points
1 Answer
Stacy Villibord
2,017 Points
Correct my syntax

Posted April 22, 2020 3:32am by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
Caleb Newell
12,283 Points
SQL limit

Posted March 11, 2020 1:56pm by Caleb Newell

Caleb Newell
12,283 Points
3 Answers
Kalif Yusuf
4,056 Points
Not sure, what is wrong with the away I answered the question

Posted February 29, 2020 7:04pm by Kalif Yusuf

Kalif Yusuf
4,056 Points
1 Answer
Mayo Toyota
2,121 Points
genre = "Science Fiction"

Posted February 15, 2020 9:17pm by Mayo Toyota

Mayo Toyota
2,121 Points
1 Answer
Daniil Kalinkin
853 Points
I would type in ______ at the end of an`ORDER BY` clause to order in descending order. What should I write here?

Posted January 30, 2020 12:24am by Daniil Kalinkin

Daniil Kalinkin
853 Points
1 Answer
Fredrick Adegoke
1,983 Points
Unsure why my query is failing

Posted December 11, 2019 10:28am by Fredrick Adegoke

Fredrick Adegoke
1,983 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers
sevdiye ozlutas
1,453 Points
I am struggling to write a query for this question. What is should be?

Posted August 26, 2019 11:09am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Yung Kazi
6,997 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,997 Points
2 Answers
Adam Tyler
14,865 Points
Why does this need a WHERE clause?

Posted June 19, 2019 4:02pm by Adam Tyler

Adam Tyler
14,865 Points
1 Answer
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
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
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
Dinesh Dewnarain
1,089 Points
Limit rows

Posted February 10, 2019 4:12pm by Dinesh Dewnarain

Dinesh Dewnarain
1,089 Points
1 Answer
Mark Chesney
11,698 Points
link in GitHub not working; please help

Posted January 11, 2019 12:34am by Mark Chesney

Mark Chesney
11,698 Points
1 Answer

Prev Page 1 of 3 Next

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