一条强力的sql

来源:互联网 发布:易语言qq群验证源码 编辑:程序博客网 时间:2024/05/17 07:44

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

原创粉丝点击