Today I found nice sites that has good sample how to get the maximum
record in a group check it out.
~jk groupwise max
How to find max row per group without subqueries
This entry was posted on February 19, 2009 at 7:27 am and is filed under SQL with tags group by, having, max, query, select, SQL. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Blog at WordPress.com. The Black-LetterHead Theme.
Get every new post delivered to your Inbox.