I have a boxscore data set of a basketball team with mm:ss played (ex. 44:46) when I uploaded the csv to the table the values whose greater than 24 somehow became hh:mm (ex. 44:46 became 44:46:00) while the others just…
I have two tables one is users and other is students. I wish to execute a single SQL statement that inserts into both these tables different values. The id is PK for users and I have referenced the same id…
I have a SQL table that can reference another record in the table as its parent but should not reference itself. I have attempted to enforce this with a CHECK constraint but my attempts have failed as the id is…
Need to aggregate latest product prices of all products from batchTransaction Table, relevant Columns: id - Unique productId - Not unique transactionValue - Value of that transaction transactionDate - date of that transaction A product can have multiple transactions but…
Name Date Score A 01-01-2023 100 A 01-01-2023 200 A 03-01-2023 300 B 02-01-2023 400 B 03-01-2023 100 B 03-01-2023 100 i have this table and i want to seperate it into multiple column of date and SUM the score…
I am creating a movie database and I have a query that finds movies by their ID and it is working. public function getMovieById($id) { $query = "SELECT * FROM movies WHERE id = ?"; $paramType = "i"; $paramValue =…
I need to Insert two Records in a new mysql table for each record in another table example: table1 id, name 1, Patrick 2, John I want to insert favorite site for each records in the second table and each…
I have a Postgres table with certain data, let's say I have 3 columns at the beginning: name age gender Name1 31 F Name2 18 M Name3 22 F Later on I want to add a new field created_date to…
I have an on premise SQL Server database that is the backend for our project management software, a Azure sql table that contains limited data used for reporting with power bi and a linked server to connect the two. Both…
Considering the following content on a jsonb field, and that the keys immediately after "audio" are random (I'll never know which value it'll be returning beforehand): is there any way I can query for the last key inside "audio" ("2814462280"…