忘_念

分类

/ 注册

全部文章（共3篇）

题解 | #查询职位城市在北京或者职位工资高于100000

SELECT job_id,company_id FROM job_info WHERE job_city = '北京' UNION all SELECT job_id,company_id FROM job_info WHERE salary > 100000;

2024-10-27

0 68

题解 | #将查询列重新命名#

select job_salary '职位工资' from deliver_record;

2024-10-26

0 38

题解 | #查询限制行数#

select * from deliver_record limit 2;

2024-10-26

0 45