Flashcards
SQL
Flashcards do conjunto (7)
- 1What does an asterisk (*) do?An asterisk (*) in the select clause denotes “all attributes”
- 2What does DISTINCT do?SQL allows duplicates in relations as well as in query results. To force the elimination of duplicates, insert the keyword DISTINCT after select.
- 3What does ALL do?The keyword ALL specifies that duplicates will not be removed.
- 4What does FROM do?It lists the relations to be scanned when evaluating the whole SELECT expression.
- 5What does AS do?The SQL mechanism for renaming relations and attributes is accomplished through the AS clause:
old-name AS new-name - 6What does % do?The % character matches any substring.
- 7What does _ do?The _ character matches any character.
Informações
- Descrição
- 1 Database FlashCards sobre SQL, criado por linneamd em 15-03-2016.
- Criado por
- linneamd
- Visualizações
- 10
- Avaliação