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

13 votes249 views2 answers
Display users in mysql
SQL
0 vote275 views1 answer
Oracle archivelog usage
SQL
0 vote270 views1 answer
Psql store procedure-return multiple table values
SQL
4 votes269 views1 answer
Find tables with column name in sql
SQL
3 votes280 views2 answers
Search text in all sql server stored procedure
SQL
0 vote283 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote273 views1 answer
Find usage of table in sql server
SQL
2 votes261 views1 answer
Mysql find tables with name
SQL
0 vote254 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote259 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL