select * from dbo_Fc_Products where TypeID in (select min(TypeID) from dbo_Fc_Products) and STypeID = 5 order by PID desc
看看这么写可以么
------解决方案--------------------------------------------------------
没什么不可以吧
------解决方案--------------------------------------------------------
整理一下：
select *
from dbo_Fc_Products
where TypeID in (select min(TypeID) from dbo_Fc_Products)
and STypeID = 5
order by PID desc
------------------------
select min(TypeID) from dbo_Fc_Products
可以用 group by 约束。
------解决方案--------------------------------------------------------
完全可以～～
------解决方案--------------------------------------------------------
SELECT * FROM [dbo_Fc_Products] WHERE TypeID = (SELECT TOP 1 TypeID FROM [dbo_Fc_Products ] ORDER BY TypeID ASC) and STypeID = 5 order by PID desc
这样写效率好像高一点，如果只取一个值的，最好不要用 IN
------解决方案--------------------------------------------------------
declare @TypeID int;
SELECT @TypeID= min(TypeID) from dbo_Fc_Products;
select * from dbo_Fc_Products where TypeID =@TypeID and STypeID = 5 order by PID desc;
这样也可以的，哈哈。