Re: Select all the rows that fulfill the criteria: only the first 2 occurences of a value in column B

[Cristian Tanasa]

Yes, I mean HAVING COUNT(Cust).

I don't think that I have the privileges to run Show Create Table.

A colleague helped me with a working statement in Oracle:

SELECT * from
(SELECT a.* , ROW_NUMBER() over (PARTITION BY Cust. ORDER BY OrderID desc) RANK
FROM Table a)
WHERE RANK IN (1,2);

It just doesn't work in MySQL, where I need it.
Any ideas?