|| ' was paid on' || :new.paydate);测试它:set status=2car_ticket表:cid int, --- the car that violated parkingregulations
lid int, --- lot where violation took
我有3个表:表1- "taxonomy_index“,其中有4列(列是nid、tid、粘稠的、创建的)。SELECT count(*), tid GROUP BY tid HAVING COUNT(*) >3
这个查询给了我两个值,一个是count,另一个是tid。(使用tid )多少次。在输出中,我希望获得每个tid使用的次数(查询1)和类型(查询2)