请考虑下表:
SELECT id, Bill_Freq, Paid_From, Paid_To, Paid_Dt, rev_code FROM psr_20160708091408;
要求是获取具有用字符串** SUM **填充的rev_code的行.
我还注意到,对于每行都将rev_code填充为** SUM **,其Bill_Freq将不为null或零.
所以我写了两个查询来获取id最低的行
基于where子句中的字符串检查查询:
select
min(id) as head_id,
bill_freq,
Paid_From,
Paid_To,
Paid_Dt
from
`psr_20160708091408` where rev_code = "**SUM**";
基于真实条件的查询:
select
min(id) as head_id,
bill_freq,
Paid_From,
Paid_To,
Paid_Dt
from
`psr_20160708091408` where bill_freq;
我没有看到有人使用第二种类型,想知道它的可靠性和失败的情况.