问一句SQL的写法

[huidan]

sql = "select DISTINCT username from book order by id desc"
这句只能取出表中的不同名字
但是我想要的是：
取出不同的名字，但也要相关的其他字段，比如ID这些

请问应该怎么写

[笨笨兔兔兔兔兔]

sql = "select DISTINCT username,id from book order by id desc"

[myboll]

sql = "select DISTINCT * from book order by id desc"

[yjb136]

sql = "select DISTINCT * from book order by id desc"

这样不对
sql = "select DISTINCT username,id from book order by id desc"
这才对呀

DISTINCT 这一个只能去限定username

如果每个字段都限定那成什么样了

[kseawolfk]

我问个问题，要是有很多字段怎么办？一个个全协上去啊？那不累死？！

[笨笨兔兔兔兔兔]

select * from [select distinct username form book] order by id desc

[笨笨兔兔兔兔兔]

写错了,不好意思

[笨笨兔兔兔兔兔]

select * from book inner join [select distinct username form book] as book1 on book.username=book1.username order by id desc

[超级大笨狼]

SELECT id ，max（其他字段）FROM book GROUP BY id

[超级大笨狼]

select * from tb where id in (SELECT id FROM book GROUP BY id
)

[超级大笨狼]

select * from book where id in (SELECT id FROM book GROUP BY id
)

[笨笨兔兔兔兔兔]

select * from book where id in (select distinct id from book)