I want to have an sql update query statement that will update the number of items of a table called people that has more than 400 items and set them to 400. the logic will look like this: Given a…
I've set up PostgreSQL Anonymizer on my database with security labels and everything works fine. I'm trying to regularly ceck if there is missing security labels on the columns of my database to telle the developers to add them in…
I am newbie to sql, and this is my first time posting question here. I created a table with 4 column. Item (which is Item no.) Description (the menu name) unit_price (price) and Qty (which is the order that has…
I'm using postgres and I try to make my request with array_agg in knex, but I have the error: "message": "Expected 1 bindings, saw 0" Does anyone know where this error may come from? And how can I fix it?…
Had a question.. | a_id | name | r_id | message | date _____________________________________________ | 1 | bob | 77 | bob here | 1-jan | 1 | bob | 77 | bob here again | 2-jan | 2 |…
My table structure is roughly as described in this post: name processed processing updated ref_time abc t f 27794395 27794160 def t f 27794395 27793440 ghi t f 27794395 27793440 jkl f f 27794395 27794160 mno t f 27794395 27793440…
I have some rows in an SQL table. I have attributes as: id, name, etc. Some of the names (in the name column) are built from some name ("xyz") and the id id name 333 regularName 555 somename.555 666 myName.666…
I have a table, it has these columns: id | tx_hash | tx_status | created_at ----------+---------+-----------+--------------------------- 15000000 | 0x0011 | 0 | 2021-07-30 06:42:00.267694 15000001 | 0x0011 | 0 | 2021-07-30 06:42:00.267694 15000002 | 0x0011 | 0 | 2021-07-30 06:42:00.267694…
Well, that is, there are two Johns and one Quill, you need to output the number of those people who have the same name. In one column there should be the total number of students with the same names SELECT…
I have a table with given values | id | level | value | | --- | ------ | ----- | | 1 | 30000 | 0.05 | | 2 | 100000 | 0.06 | | 3 | 120000 |…