请叫一个SQL语句?请多指导
请叫一个SQL语句?请多指导

select distinct(name) from tableName where total <=100(一个数值型字段) order by date(日期字段) desc

就是按日期排序后,查询出数值小于100的记录,name有多个相同的值,同一个值我只要最上面的一项

[解决办法]
select date,distinct(name) from tableName
where total <=100(一个数值型字段)
group by date
order by date(日期字段) desc
[解决办法]
你自己的语法就可以啊。

[解决办法]
那是
[解决办法]
试试top 1
[解决办法]

select date,name from tableName
where total <=100
group by date,name
order by date

[解决办法]
select name,max(date)
from tableName
where total <=100(一个数值型字段)
group by name
order by date(日期字段) desc
[解决办法]
select name,max(date)
from tableName
where total <=100(一个数值型字段)
group by name
[解决办法]
你自己的不是已经加了distinct了嘛？