一句mysql->sql语句

[hql5202004]

select min(`tbPage`.`id`) AS `id`,`tbPage`.`tName` AS `tName` from `tbPage` group by `pages`.`tMd5`);


转为sql写法要怎么写？

大概的意思是：：通过 把重复的去掉，留下最小的一个就可以了.根据tMd5.
在线等。。。。。谢谢。。。

[rucypli]

select tName,tMd5,min(id) as id
from tbpage
group by tName,tMd5

[htl258_Tony]

select min(id) AS id,tName from tbPage group by tName

[htl258_Tony]

select min(id) AS id,tName from tbPage group by tName,tMd5

应该是这个意思.

[百年树人]

select 
  min([tbPage].[id]) AS [id],
  [tbPage].[tName] AS [tName] 
from 
  [tbPage] 
group by 
  [pages].[tMd5]; 

语法转换大概是这样，但是你的语句是不对的

[ai_li7758521]

select min(tbPage.id) AS id,tbPage.tName AS tName 
from tbPage 
group by tbPage.tMd5 --? pages是不是写错了

[hql5202004]

我的是这样写的：：

SELECT MIN(tbPage.id) AS id, tbPage.tName AS tName
FROM dbo.tbPage
GROUP BY tbPage.tMd5

提示什么没有在聚合列？？

[水族杰纶]

SELECT    MIN(tbPage.id) AS id, tbPage.tName AS tName 
FROM        dbo.tbPage 
GROUP BY tbPage.tName 
--or

SELECT    MIN(tbPage.id) AS id, tbPage.tName AS tName ,tbPage.tMd5 
FROM        dbo.tbPage 
GROUP BY tbPage.tMd5 ,tbPage.tName 

[百年树人]

绕来绕去没弄懂楼主的意思，用exists吧

select 
  id,
  tName
from 
  dbo.tbPage t
where
  not exists(select 1 from tbPage where tMd5=t.tMd5 and id<t.id)