How to solve limit in select query problem?

Asked Oct 31 '18 at 18:29

Active Oct 31 '18 at 20:04

Viewed 48 times

SQL code:

select
    car_id, user_id 
from
    orders o
left join
    users u on u.id =  o.user_id
where
    o.user_id in (select id from users limit 3)

Mysql Says This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery

edited Oct 31 '18 at 19:01

Shidersz

asked Oct 31 '18 at 18:29

1

Please provide relevant sample data and expected output accordingly. – Madhur Bhaiya Oct 31 '18 at 18:31
1

What do you actually want to do? Limiting without ordering makes little sense, apart from producing "random rows". Do you want random rows? – The Impaler Oct 31 '18 at 18:33
What version of MySQL are you using? – The Impaler Oct 31 '18 at 18:34
1

@PauloCastilho there is no `TOP` in MySQL – Madhur Bhaiya Oct 31 '18 at 18:34
i use mysql 5.7 – Алексей Ягодаров Oct 31 '18 at 18:34
@АлексейЯгодаров Could you provide some sample data and expect result? – D-Shih Oct 31 '18 at 19:03
@TheImpaler Why do you think the version matters? AFAIK, it's not supported in *any* version. – Barmar Oct 31 '18 at 20:11

0 Answers0