To get the Middle Record

“SELECT TOP 1 ENO
FROM (SELECT TOP 50 PERCENT ENO
FROM EMP WITH (NOLOCK)
ORDER BY ENO ASC) AS T1
ORDER BY 1 DESC”

Explore posts in the same categories: SQL