suppose I have records like ArtNo Week A1 2 A2 2 A3 2 A4 1 A4 4 A3 6 A5 6 Result should be A1 2 A2 2 A3 6 A4 4 A5 6 In the result rowsets I need distinct ArtNo with there Max WEEk. NEED HELP...

what was your query just provide clear details.

Actually my question was different.... But thanks for reply

select max(week),artno from Table_Name group by artno

TRY THIS SELECT ARTNO,MAX(WEEK) AS WEEK FROM TABLENAME GROUP BY ARTNO

Answers

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

Ravi Shekhar

11y

718

suppose I have records like

ArtNo Week

Result should be

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

NEED HELP...

Next Recommended Forum

Why we use option (merge join)

Forum Statistics

Upcoming Events

View all