Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Run sql query on Max(Week) column in sql server
Ravi Shekhar
Oct 16 2013 6:08 AM
700
Reply
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...
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Why we use option (merge join)
Need help in Sql Query