How to view data based on range

hi everyone.

I would like to ask on how to view data based on specific range.
I have many data in dbase. example:

Year Sales
2000 8976
2001 2345
2002 3324
2003 2223
2004 2234
2005 1123
2006 5563
........
.....
.....
....
2011 3345
......
....
...

but, what should i do if i just want to display data only last 5years? even i access the system during any years in future.?
can someone help me plizz..

 

Here is the query

SELECT Sales from table_name WHERE `Year` >= ( YEAR(NOW()) - 5 )

Code (markup):

 

Yes that will help. You can add additional constraints to fit your requirement