MySQL 1

The unique column used to identify the records is called:

What is the name of the language used in creating & accessing databases?

Rearrange the code to select the ''name'' column values from the ''customers'' table.

• SELECT

• `name`

• `customers`

• FROM

Symbol to select all of the columns from the table.

Rearrange This Following SQL use LIMIT to to select the ''id'' and ''name'' columns from ''customers''. Show 12 results, starting from the fifth.

• LIMIT

• SELECT

• 5,12

• FROM `customers`

• `id`,`name`

Comparison Operator that we use in the WHERE clause is ...

• AND

• !

• ==

• BETWEEN

Fill in the blank, to select all data from table students where the city equals to ''Malang'' and sorting by `name` and only retrieve the first two records

SELECT ​ (a)   FROM `students`

WHERE​ (b)   ​ (c)   ​ (d)   ;

• *
• `city`='Malang'
• Order By `name`
• LIMIT 2

operator that used for exclude city from malang and surabaya

SELECT * FROM `student` WHERE `city` ........ ('Malang','Surabaya');

• =

• !=

• IN

• NOT IN

keyword SQL for search data in database is

• SEARCH

• IN

• LIKE

• AS

single character in SQL for search data in database using LIKE condition is ...

• #

• %

• '

• !