Offset Fetch clause :
SELECT DISTINCT * FROM [tbl_Contents] inner join [tbl_Box_Contents] on [tbl_Box_Contents].[boxID]=1 WHERE ([tbl_Contents].[Feature] = 'false') and ([tbl_Contents].[ID]=[tbl_Box_Contents].[newsID]) and ([tbl_Contents].[Approve]='true') ORDER BY [tbl_Contents].[datetimeContent] DESC OFFSET 2 ROWS;
Refer this
http://technet.microsoft.com/en-us/library/gg699618%28v=sql.110%29.aspx[
^]
or
WITH mytable AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY user_id) AS RowNumber,user_code,cloumn2,column2
FROM
tbL_user_Registration
)
SELECT
*
FROM
mytable
WHERE
RowNumber >2