Hi
Here is the solution you can get recently joined employee in organaization.
SELECT E.*,D.* FROM Emp E INNER JOIN Dept D ON E.Deptno = D.Deptno
WHERE CONVERT(VARCHAR,E.Hiredate,101) > CONVERT(VARCHAR,DATEADD(DAY,-30,GETDATE()),101)
Order by D.Dname, E.Hiredate Desc, E.Ename
It will display only those employee who was joined in last 30 days. but if you want increase or decrease day replace -30 with your value.
I hope this will help you! :)
Please let me know, if still you don't have solution.
Thanks,
Imdad