• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Go
      • • HTML
      • • iOS
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
      • • Swift
  • Luigi Cinque
    Luigi Cinque
    1,548 Points

    SQL (ORDER BY, WHERE)

    Posted September 15, 2019 9:36pm by Luigi Cinque
    Luigi Cinque
    1,548 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    2 Answers

  • Adam Tyler
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Karl Hogben
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • sj sh
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    0 Answers

  • Marat Guysin
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Dinesh Dewnarain
    Dinesh Dewnarain
    1,089 Points

    Limit rows

    Posted February 10, 2019 4:12pm by Dinesh Dewnarain
    Dinesh Dewnarain
    1,089 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Alejandro Carvajal
    Alejandro Carvajal
    9,100 Points

    Question not written correctly

    Posted January 8, 2019 6:45pm by Alejandro Carvajal
    Alejandro Carvajal
    9,100 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Alejandro Carvajal
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Gia Hoang Nguyen
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    0 Answers

  • kekai borah
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    2 Answers

  • Shahrukh Azhar Khan
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    2 Answers

  • Rhea Khanna
    Rhea Khanna
    2,838 Points

    Limiting data with SQL

    Posted October 18, 2018 11:27am by Rhea Khanna
    Rhea Khanna
    2,838 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    2 Answers

  • Sandeep Padda
    Sandeep Padda
    2,781 Points

    Help with this question?

    Posted October 16, 2018 12:53am by Sandeep Padda
    Sandeep Padda
    2,781 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Loy Yee Ko
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Raymond Moore
    Raymond Moore
    8,897 Points

    SQL Query ?

    Posted October 6, 2018 11:01pm by Raymond Moore
    Raymond Moore
    8,897 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Shain Jones
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Karen Shumate
    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
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • ct7
    PRO
    ct7
    Pro Student 964 Points

    Challenge task 1 of 2

    Posted September 1, 2018 7:29pm by ct7
    ct7
    Pro Student 964 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    2 Answers

  • Walter Guerrero
    Walter Guerrero
    6,841 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,841 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Fathima Fas-ha
    Fathima Fas-ha
    6,846 Points

    Reporting with SQL

    Posted May 24, 2018 9:47am by Fathima Fas-ha
    Fathima Fas-ha
    6,846 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

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

Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world.
Our Company
About Us
Contact Us
Community
Treehouse Stories
Student Perks
Treehouse Blog
Affiliate Program
Careers
Topics
HTML
CSS
Design
JavaScript
Ruby
PHP
iOS
Android
Development Tools
Business
Tracks
Web Design
Web Development
Rails Development
PHP Development
iOS Development
Android Development
Starting a Business
  • Treehouse Blog
  • About Treehouse
  • Privacy Policy
  • Terms & Conditions
  • © 2019 Treehouse Island, Inc.

Sign in

I forgot my password