Click here to Skip to main content
13,449,583 members (46,806 online)
Click here to Skip to main content
Articles » Database » Database » General » Statistics

Tagged as


10 bookmarked
Posted 21 Mar 2010

JOIN Instead of Repeating a Subquery

, 2 Feb 2011
Rather than use multiple subqueries to extract TOP 1 data, this shows you how to use a single TOP 1 JOIN.




This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
United States United States

  • Managing Your JavaScript Library in ASP.NET (if you work with and you don't read that, you are dead to me).
  • Graduated summa cum laude with a BS in Computer Science.
  • Wrote some articles and some tips.
  • DDR ("New high score? What does that mean? Did I break it?"), ping pong, and volleyball enthusiast.
  • Software I have donated to (you should too):

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04-2016 | 2.8.180318.3 | Last Updated 3 Feb 2011
Article Copyright 2010 by AspDotNetDev
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid