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 vote161 views1 answer
Mysql local password denied
SQL
0 vote286 views1 answer
Running mysql from bash sc
SQL
1 vote180 views2 answers
Drop table with constraints
SQL
4 votes279 views1 answer
What are the data types
SQL
1 vote157 views3 answers
String to int mysql
SQL
0 vote161 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote171 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote150 views1 answer
Postgresql add not null and not empty constraint
SQL
11 votes171 views1 answer
Oracle export view ddl
SQL
0 vote140 views1 answer
Inser into example
SQL