search

anthonydb / practical-sql

Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
Other
662 stars 409 forks source link

CH 4 Try it Yourself #2 #29

Open emiliemercier opened 3 years ago

emiliemercier commented 3 years ago

Hi!

For #2 Try it yourself example in Chapter 4, what would be the statement to file the 20 counties in the United States that have the most housing units. I am confused to what statement would be used to only show the highest 20 without using DESC.

Thank you!

Did you install PostgreSQL and pgAdmin according to the steps on page xxviii of the book's Introduction? If not, please describe your installation.

Which versions of PostgreSQL and pgAdmin 4 are you using? If you aren't sure, for PostgreSQL run the SQL command SELECT version(); and for pgAdmin 4, navigate to "About pgAdmin 4" under the "Help" menu.

Did you download the book's code examples and data from GitHub using the directions on page xxvii of the Introduction? If not, please describe how you loaded the material on your computer.

Issue or Question

Chapter, page and code listing number:

Describe the issue or your question:

Please paste the code and error message here. It's OK to alter identifying info such as a folder name

anthonydb commented 3 years ago

Hello @emiliemercier --

You want to use the LIMIT keyword.

You can find that solution with all the Try It Yourself exercises in the below file, which is in the folder of the same name in this repository:

https://github.com/anthonydb/practical-sql/blob/master/Try_It_Yourself/Try_It_Yourself.sql