var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to do this?
I need to select the row that has the highest value for a particular field.
For example, lets say we have an employee table, and an employee can appear more than 1 time because an employee has several job functions:
I need to select the row with the highest function, in this case manager( because m > c)
How can i do this, lets say the table name is Employee.
This is the query that I got.
SELECT EMP_ID, MAX(FUNCTION)
GROUP BY EMP_ID