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 vote187 views1 answer
Find largest table in mysql database
SQL
2 votes184 views1 answer
Oracle sql drop table purge
SQL
4 votes197 views1 answer
Select nls_date_format
SQL
3 votes208 views1 answer
How to check schema privileges in oracle
SQL
22 votes217 views4 answers
Mysql date_format
SQL
4 votes312 views4 answers
Remove duplicate old value in mysql
SQL
0 vote205 views1 answer
Sql DATE = GETDATE()
SQL
0 vote211 views1 answer
Check for directory in bash
SQL
0 vote205 views1 answer
Mysql where in keep order
SQL
0 vote206 views1 answer
Sql pivot without aggregate
SQL