SQL Help Needed

[ranjith23]

Hi,

We are on SQL Server 2014 version and below is my requirement.

Using which function we can accomplish this? EMPLOYEE ID & EFFECTIVE DATE are key fields

EMPLOYEE ID   EFFECTIVE DATE     SALARY      My Requirement Column
23                        01/01/2019                50000       01/01/2017 
23                        01/01/2018               50000        01/01/2017 
23                        01/01/2017               50000        01/01/2017 
23                        01/01/2016               40000        01/01/2016
23                        01/01/2015               51000        01/01/2013
23                        01/01/2014               51000        01/01/2013
23                        01/01/2013               51000        01/01/2013

[xano917]

select EMPLOYEE _ID  ,EFFECTIVE_DATE ,SALARY, Min (EFFECTIVE_DATE) OVER (  PARTITION BY EMPLOYEE _ID,SALARY ) from table 

[ranjith23]

14 minutes ago, xano917 said:

select EMPLOYEE _ID  ,EFFECTIVE_DATE ,SALARY, Min (EFFECTIVE_DATE) OVER (  PARTITION BY EMPLOYEE _ID,SALARY ) from table 

Msg 207, Level 16, State 1, Line 16
Invalid column name 'EMPLOYEE_ID'.

[xano917]

22 minutes ago, ranjith23 said:

Msg 207, Level 16, State 1, Line 16
Invalid column name 'EMPLOYEE_ID'.

yevadu va neeku udhyogam icchindi ?

[samaja_varagamana]

2 minutes ago, xano917 said:

yevadu va neeku udhyogam icchindi ?

DONT ASK THAT OSTHE CHEPPU LEKUNTE LEDHU ANTUNNA TOMBHAYYA COMPANY PPL 

[xano917]

1 minute ago, samaja_varagamana said:

DONT ASK THAT OSTHE CHEPPU LEKUNTE LEDHU ANTUNNA TOMBHAYYA COMPANY PPL 

  

[reality]

20 minutes ago, xano917 said:

yevadu va neeku udhyogam icchindi ?

We have offshore suffort ferson to do spellcheck ani antunna neti IT exfarts

[samaja_varagamana]

10 minutes ago, reality said:

We have offshore suffort ferson to do spellcheck ani antunna neti IT exfarts

Offshore telangana or AP vuuuu 

[fasak_vachadu]

33 minutes ago, xano917 said:

yevadu va neeku udhyogam icchindi ?

devudu ayi untadu nelanti vadu ... goppollu swammy 

[Edo_Okati]

1 hour ago, ranjith23 said:

Msg 207, Level 16, State 1, Line 16
Invalid column name 'EMPLOYEE_ID'.

seriuosly??? shame on u man

[fasak_vachadu]

Just now, Edo_Okati said:

seriuosly??? shame on u man

endukuvyya pillodiki nizzamgane telidu anukunta or non IT ayi untadu .... h4 vunty ..... who  knows .... okka chance ichi chudammu

[GlassMate]

54 minutes ago, xano917 said:

yevadu va neeku udhyogam icchindi ?

janalakkiii mari spoon feeding kavali antunnaru.... elanti vallaki It jobs ichi mana ijjat maname tesukuntunnam

[Edo_Okati]

4 minutes ago, fasak_vachadu said:

endukuvyya pillodiki nizzamgane telidu anukunta or non IT ayi untadu .... h4 vunty ..... who  knows .... okka chance ichi chudammu

mari ee range lo unte.... enni chances ichina waste ee

[JambuLingam]

1 hour ago, xano917 said:

yevadu va neeku udhyogam icchindi ?

[fasak_vachadu]

1 minute ago, Edo_Okati said:

mari ee range lo unte.... enni chances ichina waste ee

non IT ayithe oka 2 or 3 but same mistake malli chesthe lite.... ila 2010 ki mundu ok but ippudu unna market kurolla talent ki ela chesthe addam ga book ayi assam ayitharu