Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.80K
~344 People Reached
This member's community profile is only visible to logged in members until they have earned 15 reputation points.
Favorite Forums
Databases x 1
Favorite Tags
microsoft:sql-server x 1

1 Posted Topic

Member Avatar for Slade
Re: SQL SERVER 2000 Selecting a record based on an aggregate function
Share on Facebook Share on X Share on LinkedIn

[QUOTE=slade]Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …

Databases microsoft:sql-server
Member Avatar for manoshailu
0
9
344

The End.