I'm using keyset pagination to paginate in a table. Table looks like this: +-------------------------+ | ID | Name | private_key | +-------------------------+ | 1 | John | null | | 2 | James| abc123 | | 3 | Jane |…
I'm trying to implement an "auto-fail" kind of column in a table that includes scores for evaluations like below: Employee Category Score John Foo 5 John Bar 4 Randy Foo 3 Randy Bar 0 Daniel Foo 2 Daniel Bar 1…
I am a new sql learner. I am stuck with the following problem: Suppose I have the following table : ID detail A1 11 A1 12 A1 null A1 0 A2 11 A2 13 Now I want to create a…
In this SQL EXISTS operator tutorial has the following syntax for SELECT column_name(s) FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition); Does the column_name in the select statement of the subquery matter? From other answers it seems like…
I've got a dataset (in postgres specifically) that I need to calculate the 'user session time' for. I'm fairly positive I need to use partitioning to answer the question, but I'm not really sure how to go about it. The…
I try to use SELECT in echo because I make while loop and I want to SELECT id in table account so I will use this data inside form here is some of my php code: $sql = "SELECT *…
I have three tables x, y, z that have similar columns like this and the other columns are different: table x: id user_id month year total_price 1 1 January 2023 100.00 2 1 February 2023 200.00 table y: id user_id…
Please help with self join inside one table by different fields. given table "Items": Used PostgreSQL. I need to get all the values from such table, for which factId = 'urn:fact:drug:170' and factId1 ='urn:fact:drug:171' and factId1.value ='false' and arrayIndexes are…
I am looking to group users into separate groups based on when they bought something. A new group starts after it's been more than 90 days when the user last bought an item. Example of what I am looking for:…
I'm trying to customise related product of woocommerce First point is : the query is not updated for every requested page as I can imagine in term of server load. So how could i force to stock the custom result…