Functions Flashcards

1
Q

insert

A

вставить

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

update

A

обновить

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

delete

A

удалить

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

where

A

где

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

join

A

соединить

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

order by

A

сортировать по

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

group by

A

группировать по

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

having

A

имеющий

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

count

A

подсчет

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

sum

A

сумма

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

avg

A

среднее

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

min

A

минимум

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

max

A

максимум

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

distinct

A

уникальный

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

as

A

как

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

like

A

похоже на

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

in

A

в

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

is null

A

является null

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

is not null

A

не является null

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

union

A

объединить

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

union all

A

объединить все

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

intersect

A

пересечение

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

except

A

исключение

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

create table

A

создать таблицу

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

alter table

A

изменить таблицу

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

drop table

A

удалить таблицу

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

create index

A

создать индекс

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

drop index

A

удалить индекс

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

primary key

A

первичный ключ

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

foreign key

A

внешний ключ

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

auto increment

A

автоинкремент

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

default

A

по умолчанию

33
Q

not null

A

не null

34
Q

unique

A

уникальный

35
Q

check

A

проверка

36
Q

constraint

A

ограничение

37
Q

between

A

между

38
Q

case

A

когда

39
Q

end

A

конец

40
Q

when

A

когда

41
Q

then

A

тогда

42
Q

else

A

иначе

43
Q

coalesce

A

соединить

44
Q

nullif

A

если nul

45
Q

greatest

A

наибольший

46
Q

least

A

наименьший

47
Q

cast

A

преобразовать

48
Q

convert

A

конвертировать

49
Q

truncate

A

очистить

50
Q

limit

A

ограничить

51
Q

offset

A

смещение

52
Q

fetch

A

выбрать

53
Q

rank

A

ранг

54
Q

dense rank

A

плотный ранг

55
Q

row number

A

номер строки

56
Q

partition by

A

разделить по

57
Q

concat

A

конкатенация

58
Q

substring

A

подстрока

59
Q

length

A

длина

60
Q

trim

A

обрезать

61
Q

upper

A

верхний регистр

62
Q

lower

A

нижний регистр

63
Q

char length

A

длина строки

64
Q

round

A

округлить

65
Q

floor

A

пол (округление до целого в меньшую сторону)

66
Q

ceiling

A

потолок (округление до целого в большую сторону)

67
Q

abs

A

абсолютное значение

68
Q

mod

A

остаток от деления

69
Q

power

A

степень

70
Q

sqrt

A

квадратный корень

71
Q

log

A

логарифм

72
Q

exp

A

экспонента

73
Q

current date

A

текущая дата

74
Q

current time

A

текущее время

75
Q

current timestamp

A

текущая метка времени

76
Q

date add

A

добавить к дате

77
Q

date sub

A

вычесть из даты

78
Q

datediff

A

разница между датами

79
Q

date format

A

формат даты