跳至主要內容

查询案例

Mr.Lexon小于 1 分钟middleware

查询案例

select a.* , b.*

from employees a

inner join salaries b

on a.emp_no=b.emp_no

where a.gender='M' and a.birth_date

between '1960-01-01' and '9999-12-31' and b.salary = 70000

order by a.id limit 5;
上次编辑于:
贡献者: Lexon