查询数据库时如果要频繁查询某些数据(自用)

查询数据库时如果要频繁查询某些数据

with selName as (select name from student) ,
selTom as (select * from selName where name = 'Tom') ,
selAge as (select age from student ) ,
selSex as (select sex from student)

select *** from *** where *** = *** 

selName ,selTom ,selAge ,selSex 类似于视图的作用