Databases Reporting with SQL Ordering, Limiting and Paging Results Limiting Results

Question not written correctly

We're still using the library database with the books table. There's a title, author, genre and first_published column.

Find the earliest Science Fiction book in our library. Only one result should be returned. All columns should be selected.

as . I type my input code, it hands me an error. I completely understand the problem now. However, you guys may want to fix the question.

You see, one might think of 'earliest' as the most recent, not earliest in a timeline.

1 Answer

Steven Parker
Steven Parker
195,447 Points

I'm not familiar with that use of the word.

The word I've always seen associated with "most recent" is "latest".