Doris–基础–3.7–SQL–select
1、简单查询
select * from table11;
SELECT * FROM table11 where user_id=10001 ORDER BY user_id limit 1;
2、Join
select * from table11 t1 join table12 t2 on t1.user_id = t2.user_id;
3、子查询
select * from table11 where user_id in(select user_id from table12 );