100分求一SQL语句~``

[glvicky]

表结构如下：
name uptime
A 2000-1-2
B 2000-1-3
A 2000-1-4
C 2000-1-5
D 2000-1-6
D 2000-1-7

求：不同NAME的记录，按UPTIME倒序排列！即执行SQL语句显示：D,C,A,B

[ice_berg16]

select name,uptime from tblname order by name,uptime desc

[lxysjl]

只有接分了.好快

[helloyou0]

select distinct max(name), uptime from tblname
group by name
order by uptime desc

mysql内测试通过:)

[helloyou0]

不对，还得修改

[helloyou0]

select name,utime from (select * from t order by utime desc) a
group by name order by utime desc


OK！

[glvicky]

在SQL SERVER中运行出错。

错误如下：
服务器: 消息 1033，级别 15，状态 1，行 1
除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。

还有，你跟在)后面的a是何用？

[dsclub]

select [name],max(uptime) as cc from tablename group by [name] order by cc desc

[helloyou0]

:( mysql非让我加个东东在后面，我就加了个a

dsclub的我试了也可以，你看看

[glvicky]

唉~``原来要用别名啊，MAX和GROUP同用我也试过。。。呵，谢谢了~

解决，结贴！

[glvicky]

呃，那个~``没看到不同NAME吗？不能有NAME重复~``

[QQgenie]

简单一些的,试试加一个max():

select max(name) m_name,uptime from tblname order by uptime desc

[glvicky]

唉，你加个MAX，答案不是只有一个D了吗？！