select * from testTable tt
where id=(Select max(id) from testTable where sort=tt.sort)
where id=(Select max(id) from testTable where sort=tt.sort)
解决方案 »
- 关于大文件上传...有高人指点一下么?3Q
- 请教
- asp.net如何实现textbox的readonly 属性
- visual studio调试azure报错,各位大侠有思路吗?
- .net如何点击页面imagebotton弹出层显示所有图片(上一个,下一个))
- MVC 3 传递 List 数据 到 Controller
- 服务器的数据库和客户端数据库实现数据交换
- 关于datalist中checkbox和textbox问题,选中checkbox就验证textbox否则就不验证。详细请进……
- 请问,在datalist的<ItemTemplate>........
- 使用ArrayList与dropdownlist生成的两级城市名时产生的问题?
- 如何获得windows应用程序所在的路径?
- 如何使用转义字符?
where in_time=(Select max(in_time) from TableName where product_category_id =tt.product_category_id)
(select top 1 product_id from tablename where product_category_id=t.product_category_id order by in_time desc)
as product_id,
(select top 1 product_name from tablename where product_category_id=t.product_category_id order by in_time desc)
as product_name,
(select top 1 in_time from tablename where product_category_id=t.product_category_id order by in_time desc) as in_time
from (select distinct product_category_id from tablename) as t