SELECTING DATA QUERY Flashcards

1
Q

SELECT

A

Instruction to select a column.

SELECT data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

FROM

A

Keyword that selects a file data

FROM data file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

;

A

semicolon is used for finishing a query

SELECT data
FROM column;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

,

A

Used to separate column

SELECT name, id

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

*

A

Symbol used for selecting all column to make it easier.

SELECT *

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DISTINCT

A

It removes all the duplicates is a row of a column.

SELECT DISTINCT data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly