I am looking for the MS SQL equivalent of MySQL LIMIT.

I know that the code in MySQL is

SELECT col_name FROM tbl_name LIMIT x,y

where x = the starting row and y = the offset

E.g. SELECT movie_name FROM my_movies LIMIT 10,5

This will give me the records from 11-15

I would like to know what is the MS SQL equivalent for the above?