类似
http://expert.csdn.net/Expert/topic/2626/2626280.xml?temp=.725033
http://expert.csdn.net/Expert/topic/2626/2626280.xml?temp=.725033
解决方案 »
- ASP.NET系统中执行SQL语句时莫名其妙的删除了表中其他数据
- 用户角色的问题
- 为啥CheckBoxList控件获取数据后不显示在页面?
- 请问谁有componentone webchart(c1webchart)的帮助文档(使用说明),高分求赠100!!
- 关于msdn的问题???
- dropdownlist 点一下进入相应的页面 请高手帮帮忙
- 初学者问题:数据库放在类里的写法?
- 谁来帮帮我啊!~~~
- 急,如何获得DataGrid模版中<asp:TextBox ID="TextBox1" ruat=server/>中的内容
- 怎样转换用sqlexception 捕捉到的错误,然后对其进行转换???
- 小弟初学asp.net请问这个什么原因造成的错误?
- 文件上传时遇到的问题!
select DISTINCT attachmentid from downlog;
返回的就只有attachmentid一个字段,我怎么返回所有字段。谢谢!
FROM ttt
GROUP BY attid
ORDER BY aa
SELECT *
FROM ttt
WHERE lasttime IN
(
SELECT MAX(lasttime )
FROM ttt
GROUP BY attid
)
ORDER BY lasttime DESC
SELECT distinct *
FROM tb1
where lasttime in (select max(lasttime) from info group by attid)
我在access中测试通过,你看看
FROM tb1
where lasttime in (select max(lasttime) from info group by attid)
order by lasttime desc
刚才少了一句
You have an error in your SQL syntax near 'SELECT
也就是说第二个SELECT地方有错。是不是MYSQL不支持子查询哟?谢谢!
FROM table1
where lasttime in (select max(lasttime) from table1 group by attid)
order by lasttime desc