摘要:需要显示多个字段,其中一个字段不重复。同时按照多个组合字段排序,取前10条select TOP 10 City,Code,Name_CNfrom CGF_S_Airport where AirportID in (select min(AirportID) from CGF_S_Airport group by City)ORDER BY OrderNum asc,SearchKeys asc,C...
阅读全文
posted @ 2010-03-30 11:50