Home > Basis Data >

SIMPLE SINGLE TABLE RETRIEVAL

1. Example 1

Retrieve all information about students ('*' means all attributes) SELECT * FROM STUDENT;

Find the last name, ID, and credits of all students SELECT LNAME, STUID, CREDITS FROM STUDENT;

Find all information about students who are math majors SELECT * FROM STUDENT WHERE MAJOR = 'Math';

Find the student ID of all History SELECT STUID FROM STUDENT WHERE MAJOR = 'History';

STUID

S1001

Retrieve a list of all majors that currently have students SELECT DISTINCT MAJOR FROM STUDENT;

MAJOR

Art

CIS

History

Math

Basis Data