Basic Queries
Lesson 10Author : Afrixi
Last Updated : December, 2017
Table of Content
Code
SELECT *
FROM student;
SELECT student.name, student.major
FROM student;
SELECT *
FROM student
WHERE name = 'Jack';
SELECT *
FROM student
WHERE student_id > 2;
SELECT *
FROM student
WHERE major = 'Biology' AND student_id > 1;