Struggling with an SQL query

Question

Hi there guys basically I have a query asking me to do this...

What is the lowest rated review in the database? List the review title, date of post, author username, category name, and rating.

I've written this..

SELECT * from reviews where rating like '%1%'

Is that right? As in it's not showing anything but I am unsure why. Please excuse me as I'm trying to learn to SQL

My reviews table..

THANKS!!

you are not getting result because table dont have review 1 record — Dhiraj Wakchaure, Aug 04 '14 at 05:35
@ddw147 Is there a way of SQL showing the lowest rating without having me to input 1? — Ellie, Aug 04 '14 at 05:36
You removed a paragraph and suddenly your question stopped making any sense. — Andriy M, Aug 04 '14 at 05:55

score 3 · Answer 1 · answered Aug 04 '14 at 05:38

3

SELECT * from reviews where rating = (SELECT  MIN(rating) from reviews )

answered Aug 04 '14 at 05:38

Domain

score 2 · Accepted Answer · answered Aug 04 '14 at 05:38

2

SELECT * from reviews where rating = (select min(rating ) from reviews )

here you go !!!

answered Aug 04 '14 at 05:38

Dhiraj Wakchaure

ddw147 Thanks a lot and to everyone who answers :)! Can't pick an answer yet have to wait a couple of minutes! – Ellie Aug 04 '14 at 05:39

score 1 · Answer 3 · answered Aug 04 '14 at 08:52

1

Below query also provides similar results.

SELECT * FROM REVIEWS 
ORDER BY RATING 
LIMIT 1

answered Aug 04 '14 at 08:52

ngrashia

3 Answers3