Basic Queries

Lesson 10
Author : Afrixi
Last Updated : December, 2017


Table of Content

Code

CopySELECT *
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;