how to get list of latest record of all employee

Question

i have a table in which i am storing multiple record of same employee and there are multiple employees alsoi want to get list last record of all employeesthen base on their status divide it like on job empstatus_Id 1absent empstatus_Id 2 leave empstatus_Id 3i want to get list of all employees latest record.

Joginder Banger · Answer

and sorry for late reply;.

Joginder Banger · Answer

i have create table as per your requirement. check this one. create table #temp2(empid intstatus_id intstartdate dateenddate date) insert into #temp2 values(2271'2015-1-23''2015-2-02') insert into #temp2 values(2272'2015-2-2''2015-2-03') insert into #temp2 values(2273'2015-2-2''2015-2-04') select top 1 empidstatus_idstartdateenddate from #temp2 order by enddate desc

Sajid Hussain · Answer

my table is like this emp_Id status_Id startdate EndDate 227 1 2015-1-23 2015-2-02 227 2 2015-2-2 2015-2-03 227 3 2015-2-2 2015-2-04 i just want all three status must check this last status and put employee into that system.

Joginder Banger · Answer

create table tb (id intjob bitleave bitabsent bittodaydate date) insert into tb values(3001getdate()) select * from tb id job leave absent todaydate 1 1 0 0 2015-02-06 2 0 1 0 2015-02-06 3 0 0 1 2015-02-06 select * from tb where job=1 order by todaydate id job leave absent todaydate 1 1 0 0 2015-02-06

Joginder Banger · Answer

Hi  I think in your table have a date column you can find latest on records on the behalf of date. like this type select * from tablename order by DatecolumnName.