从数据表中查询用户信息,以下语句中不正确的是( ) 。

A. select * from user;
B. select username,password from user;
C. select * from user order username;
D. select * from user where username="admin";