The SQL SELECT Statement
The SELECT statement is used to select data from a database.
The result is stored in a result table, called the result-set.
SQL SELECT Syntax
SELECT column_name FROM table_name SELECT * FROM table_name
An SQL SELECT Example
The "student" table:
Student _No
|
Student_Name
|
Address
|
Year_Study
|
Sex
|
Date_of_birth
|
Course_No
|
ST100
|
K.Ranjan
|
Kandy
|
1
|
Male
|
17/01/1988
|
C1
|
ST101
|
N.Kumanan
|
Jaffna
|
2
|
Male
|
15/12/1989
|
C2
|
ST102
|
S.Ranjini
|
Vavuniya
|
1
|
Female
|
17/01/1989
|
C1
|
ST103
|
K.Dias
|
Colombo
|
3
|
Male
|
22/07/1987
|
C1
|
ST104
|
A.Kavitha
|
Matara
|
3
|
Female
|
20/03/1985
|
C2
|
ST105
|
L.Lavanya
|
Galle
|
2
|
Female
|
22/04/1989
|
C2
|
ST106
|
G.Moorthy
|
Jaffna
|
2
|
Male
|
12/01/1986
|
C1
|
ST107
|
F.Nathan
|
Matara
|
2
|
Male
|
29/01/1990
|
C3
|
ST108
|
A.H.M.Akmal
|
Puttalam
|
1
|
Male
|
12/12/1990
|
C3
|
Now we want to select the content of the columns named "Student_Name" and "Date_of_Birth " from the table above.
We use the following SELECT statement:
SELECT Student_Name,Date_of_Birth from student;The result-set will look like this:
+--------------+---------------+ | Student_Name | Date_of_Birth | +--------------+---------------+ | K.Ranjan | 1988-01-17 | | N.Kumanan | 1989-12-15 | | S.Ranjini | 1989-01-17 | | K.Dias | 1987-07-22 | | A.Kavitha | 1985-03-20 | | L.Lavanya | 1989-04-22 | | G.Moorthy | 1986-01-12 | | F.Nathan | 1990-01-29 | | A.H.M.Akmal | 1990-12-12 | +--------------+---------------+
إرسال تعليق