sql语句高手请进来帮忙

SELECt shopping.sp_fzr, shopping.Sp_Address, shopping.Sp_Telephone, shopping.sp_id, shoppingbf.id, shoppingbf.Sp_Code,
shoppingbf.Fw_Date, shoppingbf.fw_shike,shoppingbf.Xcfw_date, shoppingbf.Visit_id, shoppingbf.Note,
shoppingbf.Users_id, Users.Users_name, shopping.sp_Name
FROM shoppingbf INNER JOIN
shopping ON shoppingbf.Sp_Code = shopping.sp_id INNER JOIN
Users ON shoppingbf.Users_id = Users.id

where shoppingbf.xcfw_date<='2009-10-30'

我想得到以下数据中，字段为sp_id的Xcfw_date 时间字段，时间最大的一条，怎么写啊，也就是说相同的字段为sp_id，只提取时间最大的一条数据

怎么不用order by Xcfw_date desc

select top 1 xxxxx from table where xxx order by xx desc

按照倒序排列，只取第一条

最简单的办法 按时间排序 top 1

您好，图片看得不清楚QQ详谈，偶有时间

SELECt shopping.sp_fzr, shopping.Sp_Address, shopping.Sp_Telephone, shopping.sp_id, shoppingbf.id, shoppingbf.Sp_Code, shoppingbf.Fw_Date, shoppingbf.fw_shike,shoppingbf.Xcfw_date, shoppingbf.Visit_id, shoppingbf.Note, shoppingbf.Users_id, Users.Users_name, shopping.sp_Name FROM shoppingbf INNER JOIN shopping ON shoppingbf.Sp_Code = shopping.sp_id INNER JOIN Users ON shoppingbf.Users_id = Users.id

where shoppingbf.xcfw_date<='2009-10-30' and shoppingbf.Sp_Code in (select shoppingbf.Sp_Code from shoppingbf group by shoppingbf.Sp_Code having shoppingbf.Sp_Code > all)

SELECt distinct shopping.sp_fzr, shopping.Sp_Address, shopping.Sp_Telephone, shopping.sp_id, shoppingbf.id, shoppingbf.Sp_Code, shoppingbf.Fw_Date, shoppingbf.fw_shike,shoppingbf.Xcfw_date, shoppingbf.Visit_id, shoppingbf.Note, shoppingbf.Users_id, Users.Users_name, shopping.sp_Name FROM shoppingbf INNER JOIN shopping ON shoppingbf.Sp_Code = shopping.sp_id INNER JOIN

查询前加个去掉重复啊 distinct Users ON shoppingbf.Users_id = Users.id

where shoppingbf.xcfw_date<='2009-10-30'

select shopping.sp_id from shoppingbf inner join shoppingbf on shoppingbf.Sp_Code = shopping.sp_id

group by shoppingbf.Xcfw_date having shoppingbf.Xcfw_date in (select max(Xcfw_date) from shoppingbf)

..., shoppingbf.fw_shike,shoppingbf.Xcfw_date, shoppingbf.Visit_id...

找到shoppingbf.Xcfw_date改为max(shoppingbf.Xcfw_date) 加上函数