SQL Code Help Please xxxxx

[JoshuaLuke]

Hiya,

I have my query which selects staff which have a rank over 3:

 SELECT id,name FROM ranks WHERE id >= 4 ORDER BY id DESC

but aswell as displaying ranks over 3, I dont want rank 8 to show, how would I do this?

 

[Penguin]

By deleting the row.

 

[JoshuaLuke]

By deleting the row.

I don't want to delete the row... It still needs to be there