Jim Hewson
JHewson at karta.com
Tue May 6 08:44:02 CDT 2003
Gustav posted a solution for "Selecting Nth Max or Min from a table" a few days ago. In his solution, he used the in-line subquery. His final comment was: <Snip> Those not familiar with the strange [..]. syntax may look up the archives for "SQL in-line subquery" <Snip> Since I was (am) unfamiliar with this concept, I did look it up. I have a few questions. 1. Does this method run faster than a nested query? 2. What are the pitfalls? 3. What are the benefits? Any information or insight on this topic would be great. Thanks in advance to all responders. Jim