join的用法

select t.Brand,s.Id
from T_Customers as t join T_Seats as s on t.Id=s.Id

select t.Brand,s.Id
from T_Customers as t join T_Seats as s on t.Id=s.Id
where t.Age>(select AVG(age) from T_Customers)

//子查询
select * from T_Customers

select * from
(
    select * from T_Customers
)as s1

In的用法
select * from T_Customers
where Id in(1)

单列多行
select * from T_Customers
where id in
(
select BuyDate from T_Customers
)

分页相关的列
select ROW_NUMBER() over(order by Id DESC) AS rownum,
* from T_Customers

select * from
(select ROW_NUMBER() over(order by Id DESC) AS rownum,
* from T_Customers) as e1
where e1.rownum>1