Posts:
Anil Kumar has not published any posts yet.
Replies:

Assumption here is that the Timestamps and IDs are in the same order, in that case you don't need the order by clause in the where.

SELECT ID, TS, Data FROM TSOrder
WHERE ID >= (SELECT TOP 1 ID FROM TSOrder WHERE TS >='2016-07-01 00:00:00.00000')
AND ID <= (SELECT TOP 1 ID FROM TSOrder WHERE TS >='2016-07-01 23:59:59.999999')

Followers:
Anil Kumar has no followers yet.
Following:
Anil Kumar has not followed anybody yet.
Global Masters badges:
Anil Kumar has no Global Masters badges yet.