Basic Queries
Lesson 10Author : 🦒
Last Updated : December, 2017
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;