Click here to Skip to main content
12,890,970 members (57,491 online)
Click here to Skip to main content
Articles » Database » Database » General » Revisions

Tagged as


10 bookmarked
Posted 21 Mar 2010

JOIN Instead of Repeating a Subquery

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



Compare Revision Minor Date Status Editor
6 - publicly available Yes 2-Feb-11 23:55 Available Deeksha Shenoy
2 No 21-Mar-10 23:49 Composing AspDotNetDev
1 No 21-Mar-10 23:44 Composing AspDotNetDev


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
Web02 | 2.8.170424.1 | Last Updated 3 Feb 2011
Article Copyright 2010 by AspDotNetDev
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid