Query syntax error in MySql

Question

Here is my query and it's giving SQL manual syntax error in MySql.

select 
count(case when v.created_at = vv.minva then user_id) as num_new_users
from bills v 
join (select user_id, min(created_at) as minva from bills t group by user_id ) vv 
on v.user_id = vv.user_id

Can someone please help me with the problem?

The case is not correct.

jarlh
– jarlh

2015-04-07 07:33:51 +00:00
Commented Apr 7, 2015 at 7:33 — jarlh
– jarlh, Commented Apr 7, 2015 at 7:33

Stanislovas Kalašnikovas · Accepted Answer · 2015-04-07 07:34:59Z

2

You forgot to use end in CASE statement.

select 
count(case when v.created_at = vv.minva then user_id end) as num_new_users
from bills v 
join (select user_id, min(created_at) as minva from bills t group by user_id ) vv 
on v.user_id = vv.user_id

answered Apr 7, 2015 at 7:34

Stanislovas Kalašnikovas

9,0735 gold badges36 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhik Chakraborty · Accepted Answer · 2015-04-07 07:34:43Z

1

The case statement should be ended with end

select 
count(case when v.created_at = vv.minva then user_id end ) as num_new_users
from bills v 
join (select user_id, min(created_at) as minva from bills t group by user_id ) vv 
on v.user_id = vv.user_id

answered Apr 7, 2015 at 7:34

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Collectives™ on Stack Overflow

Query syntax error in MySql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related