Mysql Partition error

Asked Jun 15 '17 at 10:40

Active Jun 15 '17 at 10:40

Viewed 13 times

I am trying to create a mysql script that will search for results while at the same time filtering out duplicates of a particular field, I did some research and the code I found came in the format of something like this:

SELECT * FROM sites s INNER JOIN (SELECT h.*, row_number() over (PARTITION by muleid) as seqnum from history h ) h WHERE acceptid=2;

But it came up with the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION by muleid) as seqnum from history h ) h WHERE acceptid=2' at line 1

Is there anyone that can help?

asked Jun 15 '17 at 10:40

spaghety

MySQL does not support window functions. – Gordon Linoff Jun 15 '17 at 10:45
Check below post. https://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql – karan arora Jun 15 '17 at 11:36
+karan arora I am not trying to remove duplicate rows, I am simply trying to figure out how to filter them out of the query results. – spaghety Jun 15 '17 at 23:22

Mysql Partition error

0 Answers0