We can use the SELECT TOP 1 query to find the First or the last record in a table data. From below query we can find the exactly middle record in a table data.
SELECT TOP 1 VchDt
FROM (SELECT TOP 50 PERCENT VchDt
FROM SaleData WITH (NOLOCK)
ORDER BY VchDt ASC) AS T1
ORDER BY 1 DESC
SELECT TOP 1 VchDt
FROM (SELECT TOP 50 PERCENT VchDt
FROM SaleData WITH (NOLOCK)
ORDER BY VchDt ASC) AS T1
ORDER BY 1 DESC
