![]() |
|||
![]()
|
![]() |
![]() Click Here! |
![]() |
Teach Yourself SQL in 21 Days, Second EditionWeek 2 At A GlanceWhat's Covered This WeekWeek 1 covered the basic SQL query using the SELECT statement. Beginning with the simplest SELECT statement, you learned how to retrieve data from the database. Then you moved on to the SQL functions, which are useful in converting to money or date formats, for example. You quickly learned that you can retrieve data from a database in many ways. Clauses such as WHERE, ORDER BY, and GROUP BY enable you to tailor a query to return a specific set of records. You can use a join to return a set of data from a group of tables. Subqueries are especially useful when you need to execute several queries, each of which depends on data returned from an earlier query. Week 2 moves on to the more advanced uses of SQL:
![]() ![]() ![]() ![]() © Copyright, Macmillan Computer Publishing. All rights reserved. |
![]() |
|
Use of this site is subject certain Terms & Conditions. Copyright (c) 1996-1999 EarthWeb, Inc.. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Please read our privacy policy for details. |