SQL Query | How to increment salaries of employees who have 2 years with the organization | Datediff

[@srikanthravipati4265]

write a sql query too display employees who joined last day of the every month? can you please provide solution for this query

[@gk13.89]

The voice is too low. Video is good... Can we use job???

[@abhinavbaruah]

Why is the volume so low in the videos?

[@LearnatKnowstar]

Sorry, about the volume being low in some of the videos. We will be posting the SQL queries separately soon for anyone to reference.

[@anirbandatta3487]

Will this Query Work ? select empKey,firstname,lastname,deptName,salary , case when yrswrkd>15 then salary*1.2 when yrswrkd>10 then salary*0.15 when yrswrkd>5 then salary*0.1 when yrswrkd >2 then salary*0.065 else salary end as IncrSalary from (select *,datediff(year,hiredate,'2022-12-31') as YrsWrkd from dbo.employee) emp