I'm trying to query the pubs database for last title for each author.
The query returns each title for each author. How can I operate on max
of title?
Here's what I'm trying:
select distinct au_id,max(title_id)as title from titleauthor
group by au_id,title_id
order by au_id
dito
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!