Menu
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY CYBERSECURITY DATA SCIENCE
     ❯   

PostgreSQL Select Data


Select Data

To retrieve data from a data base, we use the SELECT statement.


Specify Columns

By specifying the column names, we can choose which columns to select:

Example

SELECT customer_name, country FROM customers;
Run Example »

Return ALL Columns

Specify a * instead of the column names to select all columns:

Example

SELECT * FROM customers;
Run Example »

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Write the correct SQL statement to select the columns city and country from the customers table.

;
        

Start the Exercise