ezra heywood Total Post:145 Points:1019 Posted by ezra heywood May-07-2013 0:26 AM MSSQL Server MSSQL Server 1 Reply(s) 1766 View(s) Ratings: Rate this: Hi Everyone! How can I get SQL Server to return the first value (any one, I don't care, it just needs to be fast) it comes across when aggregating? For example, let's say I have: ID Group 1 A 2 A 3 A 4 B 5 B and I need to get any one of the ID's for each group. I can do this as follows: Select max(id) ,group from Table group by group which returns ID Group 3 A 5 B That does the job, but it seems stupid to me to ask SQL Server to calculate the highest ID when all it really needs to do is to pick the first ID it comes across. Thanks PS - the fields are indexed, so maybe it doesn't really make a difference?