select pictype,ringtype from data group by name order by max(id) desc
你的pictype,ringtype 是什么类型的?
什么类型都错了啊,他说 data.pictype' 在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
select pictype,ringtype from data group by pictype,ringtype order by max(id) desc
笔误: select pictype,ringtype from data group by pictype,ringtype order by max(id) desc另一方法:SELECT pictype,ringtype FROM ( select pictype,ringtype,MAX(ID) AS ID from data group by pictype,ringtype ) AS X order by ID desc
大哥请指教一下原题是这样的我应该怎样改? 现在有一个表分表字段为id,name,pictype,ringtype id 是自动递增的 在name中有记录:a,b,c,a,c 我写了以下语句: SELECT distinct name FROM data order by id DESC 出错 因为我又想得到以下字段rd("id"),rd("name"),rd("pictype"),rd("ringtype") 但又要name是唯一的我怎样做了?
SELECT id, name, pictype, ringtype FROM table INNER JOIN (SELECT MAX(ID) FROM table A INNER JOIN (select name from table group by name) B ON A.name = B.name) AB ON table.id = AB.id
非到迫不得已,不要用distinct,更不要抱着distinct不放。.....
select * from data a where id =(select top 1 id from data b where a.name=b.bame order by newid()) 注意: 这个语句效率不怎么样
Rewiah(乘长风) 你的方法有时出错而且失去降序功能了
你不都是RD()吗:最后一个语句:select * from data a where id =(select top 1 id from data b where a.name=b.bame order by newid()) ORDER BY ID DESC
要效率就要放弃rd()select * from data a where id =(select min(id) from data b where a.name=b.bame) ORDER BY ID DESC
想问一下两个有什么分别?我说的rd()是在ASP中你的RD()指什么?
其实这个 select * from data a where id =(select min(id) from data b where a.name=b.bame) ORDER BY ID DESC SQL语句原理我不是好会能解释一下吗/
data.pictype' 在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
select pictype,ringtype from data group by pictype,ringtype order by max(id) desc另一方法:SELECT pictype,ringtype
FROM (
select pictype,ringtype,MAX(ID) AS ID from data group by pictype,ringtype
) AS X
order by ID desc
现在有一个表分表字段为id,name,pictype,ringtype
id 是自动递增的
在name中有记录:a,b,c,a,c
我写了以下语句:
SELECT distinct name FROM data order by id DESC 出错
因为我又想得到以下字段rd("id"),rd("name"),rd("pictype"),rd("ringtype")
但又要name是唯一的我怎样做了?
INNER JOIN (SELECT MAX(ID)
FROM table A
INNER JOIN (select name from table group by name) B
ON A.name = B.name) AB
ON table.id = AB.id
where id =(select top 1 id from data b where a.name=b.bame order by newid())
注意:
这个语句效率不怎么样
where id =(select top 1 id from data b where a.name=b.bame order by newid())
ORDER BY ID DESC
where id =(select min(id) from data b where a.name=b.bame)
ORDER BY ID DESC
select * from data a
where id =(select min(id) from data b where a.name=b.bame)
ORDER BY ID DESC
SQL语句原理我不是好会能解释一下吗/