Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
5,332 Points
Why does this need a WHERE clause?

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

Adam Tyler
5,332 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,668 Points
link in GitHub not working; please help

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

Mark Chesney
11,668 Points
1 Answer
Alejandro Carvajal
9,100 Points
Question not written correctly

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

Alejandro Carvajal
9,100 Points
1 Answer
Alejandro Carvajal
9,100 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
9,100 Points
1 Answer
Gia Hoang Nguyen
4,114 Points
what is wrong with my query?

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

Gia Hoang Nguyen
4,114 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,897 Points
SQL Query ?

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

Raymond Moore
8,897 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
13,574 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
13,574 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
6,023 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
6,023 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.