Signin Signup

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

This post was last updated for 260 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'

1 Reply

225 29 8 40 147

1 Reply

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 • 8 months

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

Usman