4
Reply

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

Ravi Shekhar

Ravi Shekhar

Oct 16 2013 6:08 AM
700

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)