Treehouse | Community

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
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
Full Stack JavaScript Techdegree Student 4,706 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
Full Stack JavaScript Techdegree Student 4,706 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,247 Points
link in GitHub not working; please help

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

Mark Chesney
11,247 Points
1 Answer
Alejandro Carvajal
7,423 Points
Question not written correctly

Posted January 8, 2019 6:45pm by Alejandro Carvajal

Alejandro Carvajal
7,423 Points
1 Answer
Alejandro Carvajal
7,423 Points
Why would a WHERE clause be necessary if I could just return the asked-for information by just ordering with ORDER BY???

Posted January 8, 2019 6:33pm by Alejandro Carvajal

Alejandro Carvajal
7,423 Points
1 Answer
Gia Hoang Nguyen
3,271 Points
what is wrong with my query?

Posted December 22, 2018 5:14am by Gia Hoang Nguyen

Gia Hoang Nguyen
3,271 Points
0 Answers
kekai borah
855 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted December 7, 2018 6:15am by kekai borah

kekai borah
855 Points
2 Answers
Dilip Kalidindi
1,042 Points
SQL Help

Posted December 5, 2018 3:51am by Dilip Kalidindi

Dilip Kalidindi
1,042 Points
3 Answers
Shahrukh Azhar Khan
2,135 Points
I am having problems writing the code for this challenge. Can someone please help me! Thanks

Posted November 12, 2018 11:06pm by Shahrukh Azhar Khan

Shahrukh Azhar Khan
2,135 Points
2 Answers
Rhea Khanna
2,838 Points
Paging through results

Posted October 19, 2018 5:43pm by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
Rhea Khanna
2,838 Points
Paging with SQL, Limit/ Offset

Posted October 18, 2018 11:30am by Rhea Khanna

Rhea Khanna
2,838 Points
3 Answers
Rhea Khanna
2,838 Points
Limiting data with SQL

Posted October 18, 2018 11:27am by Rhea Khanna

Rhea Khanna
2,838 Points
2 Answers
Sandeep Padda
2,781 Points
Help with this question?

Posted October 16, 2018 12:53am by Sandeep Padda

Sandeep Padda
2,781 Points
1 Answer
Loy Yee Ko
5,814 Points
SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; fail to return any result

Posted October 13, 2018 4:47pm by Loy Yee Ko

Loy Yee Ko
5,814 Points
1 Answer
Raymond Moore
8,152 Points
SQL Query ?

Posted October 6, 2018 11:01pm by Raymond Moore

Raymond Moore
8,152 Points
1 Answer
Shain Jones
1,151 Points
Unsure how to fix the code as the ORDERED BY is there. How can I fix this? Thanks in advance.

Posted October 5, 2018 8:00pm by Shain Jones

Shain Jones
1,151 Points
1 Answer
Karen Shumate
12,510 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
12,510 Points
1 Answer
PRO

Ethan Martin
Pro Student 1,883 Points
Retrieving Data - SELECT, LIMIT, OFFSET

Posted September 7, 2018 7:20pm by Ethan Martin

Ethan Martin
Pro Student 1,883 Points
2 Answers
PRO

ct7
Pro Student 964 Points
Challenge task 1 of 2

Posted September 1, 2018 7:29pm by ct7

ct7
Pro Student 964 Points
2 Answers
jon snow
1,774 Points
which database treehouse playground uses?

Posted August 26, 2018 1:18am by jon snow

jon snow
1,774 Points
2 Answers
Amy Hsieh
5,706 Points
Q: The page can display 20 entries, I am asked to display the 3rd page of results.

Posted August 12, 2018 7:21am by Amy Hsieh

Amy Hsieh
5,706 Points
1 Answer
Hasan Ali
1,901 Points
Not understanding what the question is asking

Posted August 8, 2018 12:34am by Hasan Ali

Hasan Ali
1,901 Points
1 Answer
Miràs Maulenov
1,787 Points
How to find missing values in a sequence?

Posted July 21, 2018 11:15am by Miràs Maulenov

Miràs Maulenov
1,787 Points
1 Answer
PRO

Takyi Akwah
Pro Student 1,049 Points
SQL Challenge task issue

Posted July 16, 2018 10:33am by Takyi Akwah

Takyi Akwah
Pro Student 1,049 Points
3 Answers
Walter Guerrero
6,840 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted June 7, 2018 11:41am by Walter Guerrero

Walter Guerrero
6,840 Points
1 Answer
Fathima Fas-ha
6,758 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,758 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.