click below
click below
Normal Size Small Size show me how
SQL for Beginners
SQL
| Defination | Statement |
|---|---|
| term for "collection of tables"? | Relational Database |
| collection of related data entries that consists of column and rows? | Table |
| record that contains information about a singe entity? | Row |
| What contains a single attribute for all rows in the table? | Column or Field |
| What is a request for data from a database table, or combination of tables? | Query |
| What SQL Statement picks data from a table? | SELECT |
| How do you include multiple columns in a SQL statement? | Separate with a comma |
| What do you use to select all columns from a table? | * |
| What keyword sets a number of results that return? | LIMIT |
| Which keyword selects all the unique values from a column? | DISTINCT |
| Which function returns the number of rows that matches a specified criterion? | COUNT() |
| Which clause allows you to filter records that fulfill specified conditions? | WHERE |
| What is the comparison operator for not equal? | <> |