SQL statement queries the most recent data for a table in a time period

First, the idea: query in a time period of the most recent time field, and then use the fields found with the original table for self-connection, and finally to the self-connected table to make the required fields of the query.

Second, SQL statement:

SELECT
*
From
(
SELECT
Max (i.createdate) as CreateDate,
r.websiteconfiginfo_id as WebId
From
Run R
WHERE
R.staticsendtime Between:begintime
And:endtime
and r.websiteconfiginfo_id =: WebSiteID
) as R1
JOIN run R2 on (
R1.createdate = R2.createdate
and r1.webid = r2.websiteconfiginfo_id
)

SQL statement queries the most recent data for a table in a time period