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

6 votes163 views4 answers
Mysql group by month
SQL
0 vote136 views1 answer
Sql right characters
SQL
0 vote159 views1 answer
Look at running processes redshift
SQL
9 votes146 views4 answers
Mysql show table fields
SQL
0 vote151 views1 answer
Get primary key of table
SQL
0 vote156 views1 answer
Oracle list partitions
SQL
25 votes239 views6 answers
Change column name mysql
SQL
1 vote171 views1 answer
Sql and
SQL
0 vote154 views1 answer
Sql min
SQL
1 vote170 views1 answer
Opensuse restart MySQL
SQL