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
CompTIA Project+ Study Guide: Exam PK0-003
IT Project Management Overview
Scope Planning
Other Planning Processes
Comprehensive Project Plan
Appendix B Standard IT Project Documents
Strategies for Information Technology Governance
Structures, Processes and Relational Mechanisms for IT Governance
Linking the IT Balanced Scorecard to the Business Objectives at a Major Canadian Financial Group
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
Measuring ROI in E-Commerce Applications: Analysis to Action
Governance in IT Outsourcing Partnerships
C & Data Structures (Charles River Media Computer Engineering)
The scanf Function
Trees
Problems in Arrays, Searching, Sorting, Hashing
Problems in Stacks and Queues
Problems in Linked Lists
Twisted Network Programming Essentials
Storing Web Data in an SQL Database
Using Authentication with Perspective Broker
NNTP Clients and Servers
Providing an Administrative Python Shell
Logging Events and Errors
.NET System Management Services
Using the System.Management Namespace
Querying WMI
Handling WMI Events
Instrumenting .NET Applications with WMI
WMI Security
Comparing, Designing, and Deploying VPNs
Advanced MPLS Layer 3 VPN Deployment Considerations
Supporting Multicast Transport in MPLS Layer 3 VPNs
Review Questions
Strengthening SSL Remote Access VPNs Security by Implementing Cisco Secure Desktop
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