SQL Commands: Difference between revisions

From Fact Weaver
No edit summary
No edit summary
Line 56: Line 56:
SELECT COUNT(DISTINCT birthdate)
SELECT COUNT(DISTINCT birthdate)
FROM people;
FROM people;
</nowiki>
Filtering of Numeric Values
<nowiki>
The where command can be used to filter numeric records. The following query selects all details for films with a budget over ten thousand dollars:
SELECT *
FROM films
WHERE budget > 10000;
</nowiki>
</nowiki>

Revision as of 02:43, 12 September 2023

Below I have listed the most common commands that I am using when acquiring data from a database

Selecting a single Column from a table:

This will select the column "Name" from the "People" Table.
SELECT name 
FROM people; 

Selecting multiple columns from a table:

This will select the Name and Birthrate column from the people table.
SELECT name, birthdate
FROM people; 

This will select all columns from a table.
SELECT *
FROM people; 

This will select 10 rows with all columns from a table. 
SELECT *
FROM people
LIMIT 10; 

This will select 10 rows with all columns from a table.
SELECT *
FROM people
LIMIT 10; 

Selecting all unique values from a column:

This will select all the unique values in the language column from the films Table.
SELECT DISTINCT language
FROM films;

Counting in a table:

This will count all the rows in the people table.
SELECT COUNT(*)
FROM people;

Placing a column in the count command will count all the non missing values.
This will count the number of birth dates present in the people table
SELECT COUNT(birthdate)
FROM people;

To count the number of distinct values, the following can be used
SELECT COUNT(DISTINCT birthdate)
FROM people;


Filtering of Numeric Values


The where command can be used to filter numeric records. The following query selects all details for films with a budget over ten thousand dollars:
SELECT *
FROM films
WHERE budget > 10000;