Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: GROUP BY nach ORDER BY?

   
    by DeddyH, 21. Feb 2009
  Ungetestet:SELECT ee.nickname, eed.*
  FROM employees_employees ee
  JOIN employees_employee_data eed ON ee.id = eed.emp_id
  WHERE eed.start_date =
  (SELECT MAX(employees_employee_data.start_date)
  FROM employees_employee_data
  WHERE employees_employee_data.emp_id = ee.id)
  ORDER BY ee.nickname