Skip to content

SQL, how to use SELECT

How to get data from a SQL database table

You can get data out of tables using the SELECT command.

Get all rows and columns:

SELECT * FROM people;
 age |  name  
-----+--------
  37 | Flavio
   8 | Roger

Get only the name column:

SELECT name FROM people;
  name  
--------
 Flavio
 Roger

Count the items in the table:

SELECT COUNT(*) from people;
 count 
-------
     2

You can filter rows in a table adding the WHERE clause:

SELECT age FROM people WHERE name='Flavio';
 age 
-----
  37

The results of a query can be ordered by column value, ascending (the default) or descending, using ORDER BY:

SELECT * FROM people ORDER BY name;
SELECT * FROM people ORDER BY name DESC;
→ Download my free SQL Handbook!

THE VALLEY OF CODE

THE WEB DEVELOPER's MANUAL

You might be interested in those things I do:

  • Learn to code in THE VALLEY OF CODE, your your web development manual
  • Find a ton of Web Development projects to learn modern tech stacks in practice in THE VALLEY OF CODE PRO
  • I wrote 16 books for beginner software developers, DOWNLOAD THEM NOW
  • Every year I organize a hands-on cohort course coding BOOTCAMP to teach you how to build a complex, modern Web Application in practice (next edition February-March-April-May 2024)
  • Learn how to start a solopreneur business on the Internet with SOLO LAB (next edition in 2024)
  • Find me on X

Related posts that talk about database: