SQL SELECT Statement 2

SQL SELECT Statement 2

ຄຳສັ່ງດຶງຂໍ້ມູນຈາກ

The SQL SELECT Statement

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

Fill in the Blanks

ຈົ່ງຂຽນຄຳສັ່ງດຶງຂໍ້ມູນຈາກຖານຂໍ້ມູນ?

SELECT Syntax

Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax: ( * )

Fill in the Blanks

ຄຳສັ່ງໃດທີ່ຊ່ວຍໃຫ້ເຮົາດືງ ຊື່ field ຂອງຕາຕະລາງ ທັງໝົດອອກມາ ?

SQL SELECT DISTINCT Statement

The SELECT DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.