select * from tt a where not exists(select 1 from tt where year(Day)=year(a.Day) and a.Price>Price) or not exists(select 1 from tt where year(Day)=year(a.Day) and a.Price<Price)
select * from tb A where not exists(select 1 from tb B where where year(A.day)=year(B.day) and A.price<B.price)
select * from 有一个表 a where not exists (select 1 from 有一个表 where year(日期)=year(a.日期) and 价格<a.价格) or not exists (select 1 from 有一个表 where year(日期)=year(a.日期) and 价格>a.价格)
where year(Day)=year(a.Day) and a.Price>Price)
or
not exists(select 1 from tt
where year(Day)=year(a.Day) and a.Price<Price)
from tb A
where not exists(select 1 from tb B where where year(A.day)=year(B.day) and A.price<B.price)
from 有一个表 a
where not exists (select 1 from 有一个表 where year(日期)=year(a.日期) and 价格<a.价格)
or not exists (select 1 from 有一个表 where year(日期)=year(a.日期) and 价格>a.价格)
请问“tt a”是什么意思?
假定a上表名,tt是什么意思?
偶试了一下,好像不行