search

AlisdairO / pgexercises

PostgreSQL Exercises web site code
Other
400 stars 62 forks source link

Add hint to not use LIMIT in "Simple aggregation" #37

Open thomasboyt opened 6 years ago

thomasboyt commented 6 years ago

Noticed that this question is easily solvable without using the MAX function as intended:

select joindate as latest from cd.members order by joindate desc limit 1

This just adds an extra line telling answerers not to use LIMIT (similar to the hint on a previous question).