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

9 votes156 views3 answers
Show table columns mysql command line
SQL
7 votes176 views3 answers
Select latest entry in sql table
SQL
0 vote163 views1 answer
Number(10 2) in sql means
SQL
3 votes224 views1 answer
Dbms_scheduler drop_job
SQL
0 vote161 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
2 votes169 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote168 views2 answers
Sql last updated
SQL
0 vote188 views1 answer
How to get nth number in sql
SQL
4 votes182 views2 answers
What is table in sql
SQL
0 vote171 views1 answer
Mysql backup certain tables workbench
SQL