FIT100
Sample SQL Queries
Typical:
SELECT<attribs>FROM<tables>
SELECT
Student.FirstN, Student.LastN, Student.MajorID
FROM
Student
WHERE
Student.S_ID= 0206125;
SELECT
Student.FirstN, Student.LastN
FROM
Student
WHERE
MajorID=14;