T-SQL Query: Select Middle Record

SELECT TOP 1 query in T-SQL helps to find the first or the last record of the table data sorted by some criteria. But what if we need to find exactly middle record entry in the table ? Below is a small T-SQL query snippet that demonstrates a technique how to get middle record in a single query (pay attention to the inline view used):

SELECT TOP 1 UserId
  FROM (SELECT TOP 50 PERCENT UserId 
          FROM T_USERS WITH (NOLOCK)
         ORDER BY UserId ASC) AS T1 
 ORDER BY 1 DESC

Related Posts:

• Yukon: New Features in T-SQL
• T-SQL: Leap Year Check
• HowTo Convert Table Values to Comma-Delimited String
• T-SQL: Generate Sequences in a Loop Query
• T-SQL: Optional Parameters in Select Query (Using ISNULL)
• MSSQL Tip: Get Primary Table in Relationship
• MSSQL Tip: Get Table Primary Key Column(s)
• ROWNUM [ PL/SQL ] Analog for T-SQL
• MSSQL Tip: Get Connected Columns in Related Tables
• How To Shrink Transaction Log in MSSQL 2000

How can i find middle record in access database in asp
Email:manijeh_enk@yahoo.com
thank's

Manijeh: Have you tried similar approach ?