linux强制杀死某个端口进程命令，例如80端口：

最新推荐文章于 2023-06-26 21:02:59 发布

灵魂的工程师

最新推荐文章于 2023-06-26 21:02:59 发布

阅读量1.3k

点赞数

分类专栏：编程语言文章标签： linux

本文链接：https://blog.csdn.net/GSQ518/article/details/107478324

版权

编程语言专栏收录该内容

6 篇文章 1 订阅

订阅专栏

linux强制杀死某个端口进程命令，例如80端口：

sudo fuser -k -n tcp 80

Q1
select * from employees where department_id >20 and department_id <=100 and
manager_id is not null;
Q2
select employee_id,first_name,last_name, salary*12 from employees where job_id in('IT_PROG','SA_REP','AD_VP');
Q3
select job_id,max(salary),min(salary) from employees group by job_id;
Q4
select TO_NUMBER(NEXT_DAY(LAST_DAY(sysdate),'Wednesday')-sysdate) FROM dual;
Q5
select manager_id from employees group by manager_id order by manager_ID desc NULLS LAST
Q6
select count(1) from employees group by manager_id having count(1) >2  order by 1 desc;
Q7
select max(avg(salary)) FROM employees WHERE lower(first_name) not like '%a%' or  lower(first_name) not like '%A%' GROUP BY manager_id;
Q18
select department_id, case when avg(salary) > 10000 then 'High'
 when avg(salary) > 6000 and avg(salary) <=10000
   then 'Medium'
     else 'Low' end  salaryLevel
 from employees group by  department_id