YOUR AD GOES HERE

SQL SELECT and WHERE explained | OCR A-Level Computer Science

Published 28, Oct 2026

0 12 Download

Description:
Which names does the SQL query return? Our original Route table contains Cedar (4 km), Harbour (7 km) and Meadow (9 km).

The first query selects Name from Route where Distance is at least 7. WHERE keeps Harbour and Meadow; SELECT Name returns their names only. This SELECT reads data without changing the stored table.

Now change the comparison to strictly greater than 7. Only Meadow remains: seven is equal to seven, while nine is greater. Without ORDER BY, the sequence of multiple result rows is not guaranteed. The exact SQL is shown and explained in the video.

An original OCR A-Level H446 database explanation from RecallStride. Read the full database lesson free: https://recallstride.com/ocr-h446/1.3.2

#RecallStride #ALevelComputerScience #OCRH446 #SQL #Databases

Releted More Videos

Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Adding dataset and column arguments into a function from a named vector -rlang question
Roel Van de Paar

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Unix: Querying application versions in Debian-style Linux versions
Peter Schneider

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

SQL : SQL Select Statement
Hey Delphi

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

#68 Java Creating Strings – Different Ways with Examples

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Python Interview Question #pythonprogramming #interview #python #programming
Coding With Sagar

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

SQL : SQL Select empty
Hey Delphi

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

06: PostgreSQL understanding the SELECT statement
theurbanpenguin

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

SQL : select true if more then 0 in t-sql
Hey Delphi

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Trust vs Will: Why a Trust Avoids Probate
Gilfix Law

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

How Prop 19 Can Cost Your Family Millions in Taxes
Gilfix Law

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

SQL : SQL Select Newest Records based on Duplicate Records
Hey Delphi

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

call for service #shorts #contenttips
Idy zillion

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

NDA 1 2026 Exam Analysis ???????? Live Paper Discussion ???? UPSC NDA Exam | NDA 1 2026 | Defence Wallah
Defence Wallah

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Data Cleaning with SQL String Functions | Clean Messy Text Data (Beginner)
LetsUpgrade

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Impress your crush using Python Code ❤️
AI Toolz

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

#2 How can teachers choose technologies for their classroom?
Teaching English with Oxford

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

SQL Select Queries #orderby #sql #sqlforbeginners #shorts #education #sqlqueries #where #exploresql

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

The CIA Had a Gun That Could Give You a Heart Attack
Dead Drop Archives

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Is it possible to use wildcard in the SELECT line of a sql statement?
Roel Van de Paar

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Python 65 String Split
John Hammond

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

???? The Number of Employees Reporting to Each Employee | SQL Query with GROUP BY & JOIN | LC SQL #30
CodeCrafting with Vishnu

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

How To Calculate Theoretical Yield and Percent Yield
The Organic Chemistry Tutor

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

#2 SQL for Data Analysis | Basic SELECT Queries in SQL
SQL Coder

SQL SELECT And WHERE Explained OCR A Level Computer Science - YouTube Auto PHP Script

Find the max length of the value in a column #sqlserver
Haritha Computers & Technology

YOUR AD GOES HERE