* Get rid off duplicate events Select Name, Code ; From mytable ; Group By Name, Code ; INTO CURSOR crsTemp1 NOFILTER * Get result Select Name, COUNT(*) AS EventCount ; From crsTemp1 ; Group By Name ; HAVING EventCount > 4 INTO CURSOR crsResult>Okay I need to extract records in a table based on it occuring in the table more than 4 times, each time having a different event code.
>Name Code >John Smith emd1 >John Smith emd2 >John Smith emd3 >John Smith emd4 >John Smith emd5