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…
We're exporting bacpacs from Azure SQL Databases to Storage Accounts via New-AzSqlDatabaseExport. Docs for that command: https://learn.microsoft.com/en-us/powershell/module/az.sql/new-azsqldatabaseexport What's the minimum role required for a SQL user to do this? We're trying to maintain the least privileges rule. Having a single…
I have the following table of inventory stock symbols and want to fetch the highest alphanumeric value which is AR-JS-20. When I say "highest" I mean that the letter order is sorted first and then numbers are factored in, so…
I have 2 tables orders order_id 1 2 3 orders_details order_id sku ordered received 1 abc 10 10 1 xyz 10 10 2 abc 10 6 2 xyz 10 0 3 abc 10 0 4 xyz 10 0 I would…
I would like to ask you for advice as I don't know which method to use: For example with this query in Mysql i have this table: user_Id name age photo 1 Zack 23 Blob[2.1] 1 Zack 23 Blob[3.3] 1…