我如何使此代码工作，以便键入的最小值与我们从查询中获得的体验相同

Question

create table employee(
employ_id int (11),employee_name varchar(30),exp_in_months int(20),monthly_salary float );
insert into employee values ('1','manjesh','30', '11000');
insert into employee values ('2','raj','10', '5000');
insert into employee values ('3','johny','15', '8000');
insert into employee values ('4','joy','12', '7000');
insert into employee values ('11','pooja','10', '46000');
insert into employee values ('20','radha','40', '46000');
insert into employee values ('5','kirthi','10', '6500');

我们可以看到raj，pooja，kirthi有(10(年的最低&同样的经历，所以我们只能找到这三个月的工资。

或者问题是

组织中资历最浅的员工收到的总工资，如果不止一名员工有相同的经历，则按输入顺序打印结果。。。。。

我只试过这个

Select MIN( monthlySalary) as Salary 
from Employee 
order by monthlysalary desc;

Answer 1

使用子查询来获得最低体验，并使用它来筛选员工。

SELECT employee_name, monthly_salary
FROM employee
WHERE exp_in_months = (SELECT MIN(exp_in_months) FROM employee)
ORDER BY monthly_salary DESC