I am having a table marks, I need to print the details of names having continuously increasing marks. Table : Marks Name Sem Marks A 1 80 A 2 90 A 3 95 B 1 80 B 2 70 B…
I need some SQL help. I have a table where I'm trying to get the % split between online sales and POS sales. Below is the query I have written and the screenshot is what I get, but I don't…
In a one-to-many relationship, users have many contracts. However, I only want the most recent contract for a specific set of users. My query to get all contracts for users look like this: SELECT userid FROM contract WHERE userid IN…
I have the following table with one row. I have tried to query this table to return authors under the age of 40 and have been unable to do so. CREATE TABLE bookstuff ( data JSON ); insert into bookstuff(data)…
I am trying to get the oldest record for every status update/change in the following table. Table (status_updates) : id entity_id status date 7 2 Approved 2022-02-10 6 2 Approved 2022-02-05 5 2 Approved 2022-02-04 4 2 OnHold 2022-02-04 3…
How to fetch a result of an int column data type from a table and if no record found select 0 as default in microsoft sql azure I had tried ISNULL but it does not work. In case there is…
I have simple table table_b id (integer) data (json) text (text) 1 {} yes 2 {} no Json look like {"types": [{"key": "first_event", "value": false}, {"key": "second_event", "value": false}, {"key": "third_event", "value": false}...]} I just want to modify data and…
My table looks like this: id data 1 {tags: {"env": "dev", "owner": "me"}} I want to fetch the data and inside the select query convert the data column to the following format: id data 1 {tags: [{"key": "env", "value": "dev"},…
const friendIds = friends.rows.map((friend) => friend.friend_id); console.log("list", friendIds); //list [ 50, 51 ] const users = await pool.query( "SELECT * FROM super_user WHERE user_id NOT IN(ARRAY[$1])", [friendIds] ); I want to query all users where the user_id does not equal…
I am trying to write a simply query that will delete an event based off its event_id. That event_id could be in 1 of 3 tables in a database however. Leagues Tournaments Trainings Each event_id is generated by a randomizer…