检索单独的记录：

SELECT * 
FROM transaction t1
WHERE Name LIKE '%Car Wash%'
  AND NOT EXISTS ( SELECT NULL
                   FROM transaction
                   WHERE t1.id <= id
                     AND Name LIKE '%Car Wash%' -- maybe not needed? not specified
                     AND Price = 0 );

仅检索其金额：

SELECT COUNT(*)
FROM transaction t1
WHERE Name LIKE '%Car Wash%'
  AND NOT EXISTS ( SELECT NULL
                   FROM transaction
                   WHERE t1.id <= id
                     AND Name LIKE '%Car Wash%'
                     AND Price = 0 );

小提琴

您可以选择

select 
    from my_table 
    where name like '%car%' and price > 0

数一数

select count(*)
    from (
       select 
       from my_table 
       where name like '%car%' and price > 0
    ) t

我把这个问题解释为“在第一行价格>0的后面有多少行可以洗车”。如果是：

select count(*)
from (select t.*,
             min(case when price = 0 then id end) over () as id_at_0
      from transaction t 
     ) t
where name = 'Car Wash' and id > id_at_0

SELECT * FROM MyTable myTable1
  AND NOT EXISTS ( SELECT NULL FROM MyTable
                   WHERE myTable1.SortColumn <= SortColumn
                     AND ExpressionColumn = True );