假设表名为a,数据库为oracle
select * from a a1 where id=(select min(id) from a a2 where a2.brand=a1.brand)
order by a1.id desc
oracle里还有另外一种方法更好的,是一个关键字
sql server 的话设表的别名要用as
select * from a as a1 where id=(select min(id) from a as a2 where a2.brand=a1.brand)
order by a1.id desc
select * from a a1 where id=(select min(id) from a a2 where a2.brand=a1.brand)
order by a1.id desc
oracle里还有另外一种方法更好的,是一个关键字
sql server 的话设表的别名要用as
select * from a as a1 where id=(select min(id) from a as a2 where a2.brand=a1.brand)
order by a1.id desc
解决方案 »
- apache问题 小弟我搞了好几天了也没搞好
- 还是正则,怎么去掉id=和title=内的值!!!
- 关于rewrite网址转向,可不可以指定一个不转,其它的都转?
- 请问这个文件xml.php代码附后是不是用来处理xml文件的?谢谢
- supplied argument is not a valid MySQL result resource in
- 兄弟进来帮我看看,这样关闭连接对不对?
- 在session中,unset()和destroy()在删除上有什么区别
- 求“新动力商务网新闻系统多功能修改版”的源代码
- Warning: mysql_connect() [function.mysql-connect]: Access denied for user ....
- 求sql写法,b2b网站搜索商家如何限制出现的次数?
- 急,求助 php中,session变量不能在页面间传递吗??
- 重金悬赏!!!!(奖金好商量)
------------------
正解!
的也报错,其他都是错的。其他的查出所有 brand ,我只要显示一个 brand You have an error in your SQL syntax near 'select min(id) f
如果按你图示结果
SELECT id,brand FROM TABLE GROUP BY brand order by id asc 完全可以实现
如果按你这种说法:'可是我现在想要其按 id desc '
SELECT id,brand FROM TABLE GROUP BY brand order by id desc 完全可以实现