Select *
FROM orders A
Where EXISTS(
Select COUNT(1)
FROM orders
Where employeeid= A.employeeid
AND orderid> A.orderid
HAVING COUNT(1)< 3)
ORDER BY EmployeeID
mysql之分组 取前二
最新推荐文章于 2022-11-18 10:10:24 发布
Select *
FROM orders A
Where EXISTS(
Select COUNT(1)
FROM orders
Where employeeid= A.employeeid
AND orderid> A.orderid
HAVING COUNT(1)< 3)
ORDER BY EmployeeID