我有这样的脚本查询选择。我想从查询选择中搜索值最大和最小'jumlah'。
SELECT
"B"."company" AS "B__company",
"User"."company" AS "User__company",
"Transaction"."create_date" AS "Transaction__create_date",
extract(day from "Transaction"."create_date"),
sum(cast("PLNPostpaid"."jumlahrek" as integer)) as jumlah,
sum("Transaction"."price_buy") as jumbuy,
sum(("Transaction"."price_sell")-("Transaction"."price_buy")) as admin
FROM "public"."transactions" AS "Transaction"
LEFT OUTER JOIN "public"."users" AS "User" ON ("User"."id" = "Transaction"."user_id")
FULL OUTER JOIN "public"."users" AS "B" ON ("B"."id" = "User"."bank")
LEFT JOIN "public"."inboxes" AS "Inbox" ON ("Inbox"."id" = "Transaction"."inbox_id")
LEFT JOIN "public"."pln_postpaids" AS "PLNPostpaid" ON ("Inbox"."id" = "PLNPostpaid"."inbox_id")
WHERE "Transaction"."create_date" >= '01-May-2015 00:00:00' AND "Transaction"."create_date" <= '31-May-2015 23:59:59'
AND "Transaction"."product_id"=100
GROUP BY extract(day from "Transaction"."create_date"), "Transaction"."create_date", "B"."company", "User"."company"
,我想实现到php。有人能帮我吗?
- 我认为你需要一个子查询来选择最小和最大。例如
WITH all_data AS ()——你最初的请求在这里)SELECT MIN (jumlah) as min_jumlah, MAX(jumlah) as max_jumlah从all_data
- 不清楚你的代码代表什么语法。如果您从php编译查询,那么您不应该使用这样的引号。包含查询的整个字符串应该用双引号括起来,但是你不需要在里面用这些双引号。