tag:blogger.com,1999:blog-6082652835152798567.post4376695427367584885..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Part 5 - SQL query to find employees hired in last n monthsUnknownnoreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6082652835152798567.post-39224978587511014332020-01-13T03:59:36.414-08:002020-01-13T03:59:36.414-08:00sir ""datediff"" function is n...sir ""datediff"" function is not working in oracle 10g sir it showing error like """ datediff is invalid identifier """ sir alternative of detediff function please tell memuledivyaswapna1739@gmail.comhttps://www.blogger.com/profile/12057748512039802715noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-88383358388166272472019-09-05T23:19:33.604-07:002019-09-05T23:19:33.604-07:00with EmpCTE as(
select *, Dense_Rank() Over(order ...with EmpCTE as(<br />select *, Dense_Rank() Over(order by HireDate) as RowNo from Employees<br />) select * from EmpCTE where RowNo = 3Lokesh Mhttps://www.blogger.com/profile/03655521626676621501noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-83883080896975421252019-08-15T02:36:57.511-07:002019-08-15T02:36:57.511-07:00How to find a third oldest Employee in a table?How to find a third oldest Employee in a table?Manikandanhttps://www.blogger.com/profile/09085267751478164426noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-45296247749840426962019-02-11T06:54:22.543-08:002019-02-11T06:54:22.543-08:00please write command for DB"please write command for DB"Anonymoushttps://www.blogger.com/profile/14683052534001902177noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-12182923639806529342017-09-17T21:44:58.166-07:002017-09-17T21:44:58.166-07:00SELECT*
FROM [Employees]
WHERE MONTH([HireDate]) B...SELECT*<br />FROM [Employees]<br />WHERE MONTH([HireDate]) BETWEEN 1 AND 5<br />ORDER BY [HireDate] DESCAnonymoushttps://www.blogger.com/profile/04664311486433489078noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-26961779345433741322017-08-04T04:08:57.092-07:002017-08-04T04:08:57.092-07:00datediff is not working in oracle, help me?
datediff is not working in oracle, help me?<br />srikanth peddinihttps://www.blogger.com/profile/17404998448805487858noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-67906832362807665322017-05-11T12:29:38.714-07:002017-05-11T12:29:38.714-07:00SELECT * FROM Employees
WHERE DATEDIFF(DAY, HireDa...SELECT * FROM Employees<br />WHERE DATEDIFF(DAY, HireDate,GETDATE()) BETWEEN 0 AND 1Anonymoushttps://www.blogger.com/profile/07883260652228156306noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-2909930364836744482017-02-23T10:46:17.712-08:002017-02-23T10:46:17.712-08:00SELECT*
FROM EmployeeHD
WHERE DATEDIFF(DAY, HireDa...SELECT*<br />FROM EmployeeHD<br />WHERE DATEDIFF(DAY, HireDate, GETDATE()) BETWEEN 1 AND 1<br />ORDER BY HireDate DESCHareshkumar Patelnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-42513837494467701612015-10-20T11:17:05.548-07:002015-10-20T11:17:05.548-07:00how to find employees who are hired yesterday cons...how to find employees who are hired yesterday considering time into account.Anonymoushttps://www.blogger.com/profile/07978098157591634645noreply@blogger.com