query

Question

i have a table where multiple record against one employee presentand there are a number of employee also. i want to get list of last records enter against all employee.

Sajid Hussain · Answer

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

Munesh Sharma · Answer

select LAST(multiplerecord column) from table group by employee

Saber Shaikh · Answer

Get Record by Desending order of ID Select * From tbl_Name order by ID Desc just check It

Munesh Sharma · Answer

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

Sajid Hussain · Answer

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

Piyush Pansuriya · Answer

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