关于group by查询得到分组后每组的最小值的记录

http://www.bzsh.cn/software/p708/A70887099.shtml

http://www.yesky.com/19/1867019.shtml

同事的回答：使用临时表和游标

CREATE procedure tmp2008

as

CREATE TABLE #tmp

 (

   id int NOT NULL

)  ON [PRIMARY]

declare @model varchar(50)

declare cur cursor for  

   select model from phone group by model

open cur

fetch cur into @model

while @@fetch_status = 0

begin        

     insert into #tmp(id)  

            select top 1 id from phone where model = @model  

            group by model,ddate,id,rate  

            order by model,rate ,ddate,id 

            fetch cur into @model

end

close cur

deallocate cur

select a.* from phone a,#tmp b where a.id= b.id

drop table #tmp

GO