请教一句sql语句

Question

sql = "select * from book where ueser='"&uu&"' order by id desc"

我想输出所有记录，但是要用户名为uu的所有记录排在最前。

我上面的语句只能列出这个用户的记录，其他的没有，不行。
能做到吗？

Answer 1

select * from book where user = @user order by id desc
union
select * from book where user <> @user order by id desc;