Question

sql 嵌套查询怎么写

如图：我有几种分类不同的id，现在我想把相同的user_id 放在一起，请问该怎么写条件

Answer 1

select user_id,* from 表名 order by user_id

Answer 2

排序？ select* from table order by user_id

Answer 3

select distinct user_id from tableName

Answer 4

select * from table_name order by user_id;