Filtring of table in sql server
I want to filter a table which contain employees entry and exit time details. any employee can enter several time and exit several time ,I want to filter my table according latest entry time and exit time of the each day.
Rajeev KumarPosted Feb 27, 2023, 6:42 AM
select Max(EntryTime) as EntryTime, Max(ExitTime) as ExitTime from employee
group by
cast( AtendeceDate as date)
Ritesh DiyawarPosted Oct 5, 2012, 12:44 AM
I think u should write the query something like that:
select Min(ExitTime) as EntryTime, Max(ExitTime) as ExitTime from employee
group by
cast( AtendeceDate as date)