There is a jobs table, jobID state timestamp 1 inProgress 2023-11-02 10:39:37 1 some random log 2023-11-02 10:40:37 2 inProgress 2023-11-02 10:43:37 1 inProgress 2023-11-02 10:44:37 1 inProgress 2023-11-02 10:45:37 1 inProgress 2023-11-02 10:50:00 1 end 2023-11-02 11:40:37 1 inProgress…
I have a table ` table VALUES from UNSIGNED INT to UNSIGNED INT value VARCHAR(2) ` example of filling 0,100000,good 100001,200000,better 200001,300000,best --- etc. I need to query a value by number, e.g. 100 (is between 0 and 100000), should…
I'm a bit new to postgres and quite rusty with SQL. I have a users table with password_hash column which stores a hashed password through pgcrypto. id | name | email | password_hash | ----+------------+-----------------+------------------------------------+ 1 | john doe |…
I have a list of blog posts, people can leave comments and I reply to them This is how the structure looks like table structure Is there a way, with a single query, to get all posts where I'm not…
I have something like that, i need to get "triangular" number - created by summing all natural ones from 0 to n. I have such code, what should i write so i could SUM name_of_column FROM generate_series? SELECT n, CASE…
I have a Table which contains data like id, country, city,capacity. Capacity is a JSON array field which has values like [{'totalCapacity':100.0},{'totalCapacity':90.0},{'totalCapacity':80.0},{'totalCapacity':80.0}] against a row in table, so row in table looks like id country city capacity 1 usa new-york…
I have a table where each row contain nested JSON. I want to normalize this JSON into multiple tables with data. For example below is the JSON for 1 row. { "Arn":"UNLQ5HFPVXMX7", "Merchant":"UNL", "Aun":"aad9561d-17bc-4280-a44f-7fd4cdb2c57a", "ExternalArn":"b7e6d3da-4b63-44a8-adfc-884cce34288d", "Status":"Commenced", "PageIdentifier":"ValidationResult", "ProductRate":{ "RollRate":false, "IsFromRate":false…
Task: I develop messenger, and I'm trying to find only users who don't share rooms with user X. I need this to offer users new chats. Problem: I can't to write right SQL query. I was only able to get…
I have this query which selects the users for a given branch. SELECT u.first, u.last, u.id, (SELECT u1.user_type FROM users_branches AS u1 WHERE u.id = u1.user_id AND u1.branch_id = @foo LIMIT 1) FROM users AS u WHERE EXISTS (SELECT 1…
I have this code: <?php $count_item = mysql_query("SELECT * FROM stdevice JOIN stlocation ON stdevice.location = stlocation.stdev_id JOIN device_name ON stdevice.dev_id = device_name.dev_id WHERE dev_name LIKE '%$dev_name%' AND stdev_location_name LIKE '%$stdev_location_name%' AND dev_serial LIKE '%$dev_serial'"); $count = mysql_num_rows($count_item); ?> This…