Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
Run sql query on Max(Week) column in sql server
Ravi Shekhar
11y
716
1
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...
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Why we use option (merge join)
Need help in Sql Query