开发mysql时碰到问题,大家帮帮看看在mysql中怎么实现以下功能:
select top 20 * from instruments where instrCode not in (select top 10 instrCode from instruments);
我知道可以用limit但是好像limit不能用在子查询中,很郁闷啊。求高人指点。
select top 20 * from instruments where instrCode not in (select top 10 instrCode from instruments);
我知道可以用limit但是好像limit不能用在子查询中,很郁闷啊。求高人指点。
(
select instrCode from(select instrCode from instruments limit 10) as tb
) limit 20
(
select instrCode from(select instrCode from instruments limit 10) as tb
) limit 20