Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
2 Cards in this Set
- Front
- Back
|
SELECT DISTINCT
|
In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.
The DISTINCT keyword can be used to return only distinct (different) values. SELECT DISTINCT column_name,column_name FROM table_name; |
|
|
Insert SQL
|
insert into TABLE (COL1, COL2, COL3) values ('VAL1', 'VAL2', 'VAL3')
|
