SQL DISTINCT 相同的合并 和DESC 、ASC 排序

SELECT * from users as u ORDER BY userPass DESC ,usersId ASC limit 10

先按照userPass 排序，若userpass 相同，则按照usersId排序

SELECT DISTINCT u.* FROM users AS u,user_follow AS f
WHERE (u.usersId = f.followeeId AND f.followerId=3 )OR( f.followeeId=3 AND u.usersId = f.followerId)
AND u.userState=0 AND f.userFollowState=0
ORDER BY u.usersId LIMIT 6,2

DISTINCT 把相同的元素合并在一起