X
Contents
8.11 Advanced Subjects of XML 251
8.11.1 Conversion of Relational Database into XML Tree 251
8.11.2 xlink and xsl:if 254
8.11.2.1 xlink 259
8.11.2.2 <xsl:if> 260
8.12 XHTML 260
8.13 XBRL 262
8.13.1 Comparison of XBRL with XML 262
8.13.2 Taxonomy 263
8.13.3 Prepare XBRL- Based Reports 263
cha P Te r 9 sQl 267
9.1 Introduction to SQL 267
9.2 CREATE and DROP 267
9.3 INSERT, UPDATE, DELETE 268
9.4 Query—SELECT 269
9.5 WHERE Clause and Comparison 271
9.6 ORDER BY Clause 272
9.7 Aggregate Functions 273
9.8 GROUP BY Clause and HAVING Clause 273
9.9 Joining Tables 274
9.10 Subquery 275
9.10.1 Subquery—Reducing Computational Workload of Join Operation 275
9.10.2 Subquery as an Alternative to GROUP BY 277
9.10.3 Subquery—Determi ...