MIDRANGE-L » June 2008

Re: SQL statement example request

Subject: Re: SQL statement example request
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Thu, 12 Jun 2008 15:52:29 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Tim Gornall wrote:

Thanks Joe! What is "CTE"?

Just in case you didn't catch Eric's excellent post, a common table expression is the "with t1 as..." syntax that basically allows you to define one or more temporary derived tables and then use those in a further expression. It's hugely powerful.

Joe

This thread ...

Re: SQL statement example request, (continued)
- Re: SQL statement example request , Michael_Schutte
- RE: SQL statement example request , DeLong, Eric
- Re: SQL statement example request , rob
- Re: SQL statement example request , Tim Gornall

References:
- Re: SQL statement example request , Tim Gornall

Prev by Author: Re: load source concurrent maintenance
Next by Author: Re: Replacing a Disk that is "About to Fail"
Previous by thread: Re: SQL statement example request
Next by thread: Re: SQL statement example request
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact