With t1 as(select count(*) as b from table where seller_chat_id

Question

With t1 as(select count(*) as b from table where seller_chat_id

= 276583256 ), t2 as (select count(*) as b from table where seller_chat_id = 123)
select * from t1,t2

with t1 as(select count(*) as c, seller_chat_id from table group by 2), t2 (select c as a from t1 where seller_chat_id=276583256), t3(select c as b from t1 where seller_cht_id=123)
select * from t2,t3

ради любопытства можешь сказать что быстрее по эксплейну, твой или один из этих двух?

#backend #php #programming #russian

0

17.04.2020