С>DECLARE @username NVarChar(100) -- String
С>SET     @username = N'XXXXXXXXX'
С>DECLARE @state_2 NVarChar(2) -- String
С>SET     @state_2 = N'KY'
С>DECLARE @skip Int -- Int32
С>SET     @skip = 900
С>DECLARE @take Int -- Int32
С>SET     @take = 20

С>SELECT
С>    [x].[rating],
С>    [x].[city],
С>    [x].[state],
С>    [x].[firstName],
С>    [x].[lastName],
С>    [x].[description],
С>    [x].[date]
С>FROM
С>    [dbo].[mytable] [x]
С>WHERE
С>    [x].[username] = @username 
С>ORDER BY
С>    IIF([x].[state] = @state_2, 1, IIF((NOT ([x].[state] = @state_2)), 0, NULL)) DESC,
С>    [x].[date] DESC
С>OFFSET @skip ROWS FETCH NEXT @take ROWS ONLY