query

this is auto increment when new record of employee that is already present is added

select LAST(multiplerecord column) from table group by employee

Get Record by Desending order of ID

Select * From tbl_Name order by ID Desc

just check It

U have auto incremented ID only for employee .means this id is increasing only when new employee join ?

yes this table has ID that is auto incremented ,do you have any query like from u in ..... THEN CONDITION

Hi, Can you show me your table fields?
If there is a Unique ID (Auto Increment) in your table than :

SELECT MAX(UID), EMP FROM
GROUP BY EMP