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 vote325 views5 answers
Sql table intermédiaire
SQL
2 votes347 views2 answers
Sql lag
SQL
0 vote319 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote302 views1 answer
Pl/sql loop example
SQL
0 vote300 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote338 views2 answers
Extract weekday from date in sql
SQL
1 vote320 views1 answer
Snowflake rename column name
SQL
2 votes330 views4 answers
Mysql get all tables row count
SQL
3 votes311 views1 answer
Mysql replace string in table
SQL
0 vote317 views2 answers
Sql query in dax power bi
SQL