Cómo obtener la primera y la utlimo registros

[antonio_dsanchez]

si de hecho lo requiero por día, solo que tu consulta no me regresa el nombre del empleado

SELECT * FROM(
SELECT firstname, lastname, description, MAX(TimeStamp_Server) AS hora_entrada FROM
Message GROUP BY firstname, lastname, description) AS t1
LEFT JOIN
(
SELECT firstname, lastname, description, MAX(TimeStamp_Server) AS hora_salida FROM
Message GROUP BY firstname, lastname, description)
AS t2 ON (t1.firstname=t2.firstname AND t1.lastname=t2.lastname)