Create temporal table in sql

WITH new_table AS (
 			SELECT *
 			FROM existing_table
 			WHERE distance >= 20)

# You can then run multiple queries on this filtered data without 
#having to filter the data everytime  write complex subqueries.
# NB WITH/temporal tables is always defined first before writing queries.

Similar codes

0 vote318 views1 answer
Dump multiple tables mysql
SQL
0 vote318 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote355 views1 answer
For select oracle
SQL
-1 vote351 views2 answers
Postgres autoincrement primary key
SQL
0 vote331 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote338 views1 answer
No query unable to fetch row sqlite
SQL
0 vote325 views2 answers
Starting mysql service from mac
SQL
0 vote290 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote331 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote345 views1 answer
Group_concat order by
SQL