How to get last records of employees in sql?

Dawood Abbas

11y983

How do I get 68,69,82,83,94 employees last records in sql?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi11y ago
Accepted answer
hi,
try following query
select em.* from employees em join (
select max(SalId) as SalId,EmpId from employees
group by EmpId) as s on em.SalId = s.SalId and em.EmpId = s.EmpId
hope this will help you.
+1
Raja T11y ago
Hi, Try like

select * from [tbl_emps] where [alId] in( SELECT max(alId) FROM [tbl_emps] group by empid )
+1
Bharath Peggem11y ago
Hi,

See this url link may be its helps you

http://forums.asp.net/t/1904043.aspx?how+find+first+and+last+record+from+table+row+in+sql+one+query+
0