2010
2007
group by
mysql> SELECT user,MAX(salary) FROM users
-> GROUP BY user HAVING MAX(salary)>10;
phpMyEdit: Instant MySQL Table Editor and PHP Code Generator
by 2 othersphpMyEdit generates PHP code for displaying/editing MySQL tables in HTML.
1
(4 marks)