SELECT

The SELECT command gets data from a database and shows the results in a table.

Syntax

SELECT column1, column2
FROM table_name;

Example

  • Get all students' names and ages:
SELECT Name, Age
FROM Students;

Practice with the Students Table

You'll use the SELECT statement to retrieve data from the Students table, including ID, name, age, department, and GPA.

Good luck with your SQL practice!

Question number:

Up Next: Practice WHERE Queries

Donate

About

Privacy Policy

Changelog