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

Kalif Yusuf
Kalif Yusuf
4,056 Points

Not sure, what is wrong with the away I answered the question

The question is "We're using the library database again. There's a books table. There's a title, author, genre and first_published column".

Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all columns.

Select * FROM books WHERE genre = "Fantasy Genre" ORDER BY first_published ASC LIMIT 5;

It keeps saying the limit was 0 not 5

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,287 Points

The genre is just "Fantasy".

Kalif Yusuf
Kalif Yusuf
4,056 Points

Thanks Kris, Instead of writing just "Fantasy as alias", I added genre at the end.