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 vote146 views4 answers
What is unique key in sql
SQL
1 vote221 views1 answer
Oracle current sequence value
SQL
2 votes170 views1 answer
How to select from mssql
SQL
0 vote142 views1 answer
Distance calculator from lat long sql query
SQL
0 vote151 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote115 views2 answers
Influxdb delete measurement based on date
SQL
1 vote154 views1 answer
Select inside insert query
SQL
0 vote124 views1 answer
Restart sql server command line linux
SQL
0 vote142 views1 answer
Mysql show create db
SQL
5 votes128 views1 answer
Postgres integer to serial
SQL