I am trying to return the folling 7 rows form a row picked by the user. Its not working. I am new to SQL and any help is really appreiciated. Thanks in advance. Also, any code samples will really help.

Here is my current statement

Select top 7 * from Rates where Rate = '6'