using group by clause in subquery in sql

Question

I am trying to use group by clause in subquery which is in from clause

select userID,count(id) 
from 
(
    (
        select id,max(bidAmount),userID 
        from Bids 
        group by id,bidAmount
    ) 
    group by userID
);

but this gives error

Error: near "group": syntax error

Is it possible to use group by clause in subquery in from clause in sql?

Answer 1

Check your (), they are not at right places. Should be something more like this:

select w.userID,count(w.id) 
from (select id,max(bidAmount),userID from Bids group by id, userID) w 
group by w.userID

Answer 2

Try this:

select userID,count(id) 
from (

select id,max(bidAmount),userID from Bids group by id,userID

) as tmp

 group by userID