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 '*) from sample b where b.emp_no <= a.emp_no) as rn from sample a) z where mod ' at line 1
Joined: Oct 13, 2005
MySQL error messages are hardly informative. If you want us to help, please quote the entire SQL statement which produces that error. It may be something tiny like a spelling error.