How to retrieve SUM value with SQL Query in Embedded Block?

This post was last updated for 295 days ago, and the information may already be changed

Could someone help me understand how I can retrieve this sum value using an SQL query in an embedded block?

I've tried this, but it's not working:
SELECT SUM("Price") AS total_price FROM blocks WHERE id='20240226045157-aamgpcf'

But this is working...
SELECT * FROM blocks WHERE id='20240226045157-aamgpcf'

SiYuan4RWvcIdbyk.png

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...
    • leolee9086

      Embedded Block can only use SQL sentence starts with "select * from blocks" for some reason
      And dataBase block can not use SQL for now