Ravi Shekhar

Ravi Shekhar

  • NA
  • 4.5k
  • 2m

Run sql query on Max(Week) column in sql server

Oct 16 2013 6:08 AM

suppose I have records like 

ArtNo                                 Week
A12


A22

A32

A41

A44

A36

A56






Result should be 

A12

A22

A36

A44

A56



In the result rowsets I need distinct ArtNo with there Max WEEk.

NEED HELP...

Answers (4)