Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-17 : 22:11:00
|
David writes "I am building my first database application to organize articles for a web site. What I am trying to do is show the newest article for each author in the database. Each author has a unique AuthorID, and each article has an ArticleID and ArticleDate.
What I need to do is create a page that displays 1 article (the newest article) per author. I would appreciate any help or suggestions, please let me know if any more information is needed. Thanks.
(SQL 7)"
|
|
|
|
|
|
SQL Query