Flylib.com
Chapter 4. Advanced SQL Coding
Previous page
Table of content
Next page
034 - Chapter 4. Advanced SQL Coding <ul><li> <p clas><script> function OpenWin(url, w, h) { if(!w) w = 400; if(!h) h = 300; window. open (url, "_new", "width=" + w + ",height=" + h + ",menubar=no,toobar=no,scrollbars=yes", true); } function Print() { window.focus(); if(window.print) { window.print(); window.setTimeout('window.close();',5000); } } </script><span></span></p> <table width="100%" cellpadding="0" cellspacing="0" border="0"><tr valign="top"></tr></table> <table width="100%" height="20" border="0" cellpadding="0" cellspacing="1"><tr></tr></table> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td align="center"><table width="95%"><tr><td align="left"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size="1" color ="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td valign="top" width="76" rowspan="4"><img src="/books/2/607/1/html/2/images/0131007718/0131007718_xs.jpg" width="76" height="95" border="0"></td> <td valign="top">DB2 Universal Database for OS/390 v7.1 Application Certification Guide<br>By Susan Lawson<br> </td> </tr> <tr><td>Table of Contents</td></tr> <tr><td></td></tr> <tr><td valign="bottom">Part 2. Structured Query Language</td></tr> </table> <hr size="1"> <br><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top"> <h2>Chapter 4. Advanced SQL Coding</h2> <ul> <li><p>Subqueries</p></li> <li><p>Unions</p></li> <li><p>Joins</p></li> <li><p>Nested Table Expressions</p></li> <li><p>CASE Expressions</p></li> <li><p>Row Expressions</p></li> <li><p>OLAP and Star Joins</p></li> </ul> <p>This chapter covers some of the more advanced features found in DB2's SQL. We start with discussions on the constructs of subqueries, unions, and joins. Then we examine nested table expressions, the CASE expression with its ifthenelse logic, row expressions, and OLAP features.</p> <img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="1" border="0"> </td></tr></table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size ="1" color="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding ="0"><tr><td valign="top" align="right">Top</td></tr></table> </td></tr></table></td></tr></table> </li></ul>
Previous page
Table of content
Next page
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors:
Susan Lawson
BUY ON AMAZON
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
SWT/JFace Mechanisms
Layouts
Combos and Lists
Text Controls
Scales, Sliders, and Progress Bars
C++ How to Program (5th Edition)
Self-Review Exercises
Sorting Algorithms
E.2. Redirecting Input/Output on UNIX/LINUX/Mac OS X and Windows Systems
G.3. Class Screen
L.1. Introduction
Postfix: The Definitive Guide
Email and the Internet
Receiving Limits
Content-Checking
Content Filtering
LDAP
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Two Principles
Chapter Eight Creating Visions Biased to Your Solution
Chapter Ten Vision Re-engineering
Chapter Fourteen Getting Started with the Process
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Twisted Network Programming Essentials
Web Clients
Working with POST Data from HTML Forms
Using a Web Client to Update Resources Through REST
Running a Twisted Application as a Daemon
Managing Multiple Services
Microsoft VBScript Professional Projects
Procedures
Customizing the Start Menu and Quick Launch Toolbar
Mapping Network Printers and Disks
Creating Administrator Accounts
Appendix B Whats on the Companion Web Site
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies