title: Get top first record from duplicate records having no unique identity
body: <p>I need to fetch top first row out of each duplicate set of records from table given below.
  I need to use this query in view</p>
  <p>please no temp table as I have already done it by adding identity column and min function and group by. I need solution without temp table or table variable</p>
  <p>This is just sample data. Original has 1000s of records in table and I need just result from top 1000, so I can't use <strong>distinct</strong></p>
  <p>I am using SQL Server 2005</p>
  <p><a href="https://i.stack.imgur.com/Qj8A3.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Qj8A3.png" alt="alt text" /></a></p>