hive语法

1. where 条件为查询结果且不唯一

用 in 连接

	select name,company
	from reader
	where reader_id in (
		select min(reader_id)
		from borrow_log
		group by reader_id
		having count(1) >=2 );