Hi,
This is my First project, I am not expecting any money only support .
I conducted some research, which you can see in the file below. Please take a look at my script; it is only a sample.
I have a 4 years of experience, I have good hand on
Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
Please let me know if you are satisfied.
WITH CTE AS(
SELECT [ID_NUM],[ORG_POS],[POS_SEQ],[SAL_RVW_SEQ],[SAL_RWV_DTE],[EARNINGS]
,RANK()OVER(PARTITION BY [ID_NUM],[ORG_POS] ORDER BY [EARNINGS] desc,[SAL_RWV_DTE] )RN
FROM [Training_DB].[dbo].[IND_PAY_HIST]
)
select [ID_NUM],[ORG_POS],[POS_SEQ],[SAL_RVW_SEQ],[SAL_RWV_DTE],[EARNINGS] from CTE WHERE rn=1