..................问一句SQL语句的问题................(20分)

JasonLaw · 2008-06-15

select top 5 distinct fName from TableName order by fID DESC

当然，上面那条是不能运行成功的。。。。。

但是我想你应该能明白我的意思。。

请问这句SQL语句要如何修改。才能达到目的呢？

kaida · 2008-06-16

select distinct top 5 fName from TableName order by fID DESC

ljffly100 · 2008-06-16

select distinct top 5 fName.* from TableName order by fID DESC

a_san · 2008-06-16

sele fName distinct top 5 from TableName order by fID DESC

wwsm-zjx · 2008-06-16

sele top 5 from (sele distinct fName from TableName) a order by fID DESC

ctaxp · 2008-06-16

select top 5 from (select distinct fName from TableName order by fID DESC)

007vivi · 2008-06-16

select top 5 from(select distinct fName from TableName)b order by fID Desc

JasonLaw · 2008-06-16

多人接受答案了。