tailieunhanh - SQL VISUAL QUICKSTART GUIDE- P50

SQL VISUAL QUICKSTART GUIDE- P50:SQL (pronounced es-kyoo-el) is the standard programming language for creating, updating, and retrieving information that is stored in databases. With SQL, you can turn your ordinary questions (“Where do our customers live?”) into statements that your database system can understand (SELECT DISTINCT city, state FROM customers;) | Index Index DBMS-specific SQL features continued altering tables 373 375 approximate numeric types 75 BLOB data types 72 Boolean types 76 calculating medians 452 changing case of character strings 141 character string types 71 column aliases 91 comparing values in subqueries with ALL 290 concatenating strings 136 309 converting data types 159-160 CREATE TEMPORARY TABLE support 368 CREATE VIEW statement 390 creating aliases with AS clauses 91-92 cross joins 205 dates 445-450 datetime data types 79 defining check constraints 365 DELETE and TRUNCATE statements 336 derived columns 129 determining order of operator evaluation 133 displaying table definitions 316-318 DISTINCT aggregate functions 181 dropped tables 376 dropping views 398 duplicate rows 437 evaluating conditional values with CASE expression 164 exact numeric data types 73-74 EXCEPT operations 313 extracting part of datetime or interval 153 extracting substrings 138-139 filtering ranges 120 finding rows with extreme values 453 generating sequences 410 414 getting current date and time 154-155 handling sorting 98 hierarchies 459 461 462-463 464 IBM DB2 versions 20 identifiers 66 67 indexes 380 382 INSERT statements 326 inserting column values with DEFAULT clause 348-349 INTERSECT operations 311 interval data types 80-81 joins with WHERE and JOIN clauses 202 length of character strings 148 limiting number of returned rows 421-429 lists filtered with IN condition 121-123 making new table from existing one 371-372 metadata retrieval 439-444 Microsoft SQL Server versions 10 midstream changes to running statistics 455 modifications with CREATE TABLE listings 342 modifying row values with UPDATE 331-332 nulls 84-85 98 126 167 345 number and datetime formatting 90 operators and functions for 131 132 Oracle versions 17 ORDER BY clause for columns in 100 OUTER JOIN syntax 237 239 240 241-242 246 pattern matching 114-117 pivoting tables 456-457 POSITION function for finding substrings 151 PostgreSQL versions 30 .