SELECT keywords/syntax

Question 1

Represents any sequence of zero or more characters

Answer 1

%

Question 2

Represents any single character

Answer 2

_

Question 3

Match any from a list of values. If characters or dates are used in the list, they must be

enclosed in single quotation marks (‘ ‘)

Answer 3

IN

Question 4

Year with 4 digits

Answer 4

%Y

Question 5

Year with 2 digits

Answer 5

%y

Question 6

Abbreviated month name in the current locale
(Jan, Feb, …)

Answer 6

%b

Question 7

Full month name in current locale

Answer 7

%M

Question 8

Month with 2 digits

Answer 8

%m

Question 9

Hour with 2 digits between 00-23

Answer 9

%H

Question 10

Hour with 2 digits (01-12)

Answer 10

%h

Question 11

Abbreviated weekday name in the current

locale

Answer 11

%a

Question 12

Minute with 2 digits.

Answer 12

%i

Question 13

Seconds with 2 digits

Answer 13

%s

Question 14

Day with English suffix (1st, 2nd, …)

Answer 14

%D

Question 15

Day with 2 digits

Answer 15

%d

Question 16

Day of the year (001-366)

Answer 16

%j

Question 17

Day of the week (0 = Sunday)

Answer 17

%w

Question 18

Time in 12-hour format, followed by AM/PM;

Short for ‘%I:%i:%S %p’

Answer 18

%r

Question 18

AM/PM according to the current locale

Answer 18

%p

Question 19

Time in 24-hour format. Short for

‘%H:%i:%S’.

Answer 19

%T

Question 20

A literal % character.

Answer 20

%%

Question 21

formats the date value using the specified format

Answer 21

DATE_FORMAT(date, format)

Question 22

returns a date based on the given string and format; the format
of the string should be the same as the indicated format

Answer 22

STR_TO_DATE(string, format)

Question 23

gets the difference of date1 and date2

Answer 23

DATEDIFF(date1, date2)

Question 24

adds k days or j units to the given date

Answer 24

ADDDATE(date, k | INTERVAL j units)

Question 25

concatenates the left side of str with pad until the length is equal to len

Answer 25

LPAD(str, len, pad)

Question 26

concatenates the right side of str with pad until the length is equal to len

Answer 26

RPAD(str, len, pad)

Question 27

returns the substring of str starting at index position (or start) up to the end of str (or up to len characters); indexing starts with one

Answer 27

SUBSTRING(str, [position | start, len])

Question 28

returns the standard deviation of the values in the column col

Answer 28

STDDEV([DISTINCT] col)

Question 29

returns true if all of the subquery values meet the condition

Answer 29

ALL

Question 30

returns true if any of the subquery values meet the condition

Answer 30

ANY