Quizlet
or
Familiarize |
Learn |
Test |
|||
Play Scatter |
Play Space Race |
||||
 Combine with other sets |
Login to add to Favorites |
| Print: Term List | Flashcards |
Editing not allowed |
| Export |
Deleting not allowed |
| With group: None | |
| HTML link to set: | Tiny link: |
 Share on Facebook |
 Share on MySpace |
| Term | Definition |
|---|---|
| SELECT AVG(column_name) FROM table_name | returns the average value of a numeric column. |
| SELECT COUNT(column_name) FROM table_name | returns the number of values (NULL values will not be counted) of the specified column |
| SELECT COUNT(*) FROM table_name | returns the number of records in a table: |
| SELECT COUNT(DISTINCT column_name) FROM table_name | returns the number of distinct values of the specified column: |
| Terms | 4 |
| Creator | jtwilliams00 |
| Created | March 30, 2009 |
| Groups | None |
| Subject | SQL |
| Access | Anyone |
| Edit | Creator Only |