I have attempted to use inner joins but not sure which would connect where? Do I need to add another FK somewhere? SELECT user_name, fkbook_id FROM users INNER JOIN loans ON user_id = fkuser_id ORDER BY fkbook_id; i've managed to…
Assume a table salaries that contains employee_id, department_id and salary, as follows. e_id | dpt_id | salary ---- | ------ | ------ 1 | 2 | 1000 2 | 2 | 2000 3 | 5 | 3000 4 | 6…
I have a table, let's say, users that has a one to many relationship to another table called, say, users_attributes. The users_attributes table is a simple key-value type table with a foreign key column to the users table. Something like…
I have a table within Redshift with a self-referential ParentID to join back to the ProductID to create a hierarchy. Basic structure (full table is c6k records, with arrays up to 90 IDs): CREATE TABLE sandbox.productmk2 ( productid integer ENCODE…
I created a stored procedure for saving mails to the Microsoft SQL Server. Then I need to send them using ASP.NET Web application. Can you tell me a way to do this? It is good if this process is working…
I am working in Postgres. I have the below composite type CREATE TYPE negotiation.diff_type AS ( operation int, content text ); This is my table CREATE temp TABLE temp_input ( indication_request_id int, para_id int, line_number int, document_id int, modified_content text,…
The database has columns with the date of conclusion of the contract and the date of termination of the contract. I need to group by date the number of conclusions and the number of cancellations. I have written queries with…
I've just started to learn MySQL and I'm stuck at a seemingly simple query. I've got 5 tables for a course provider db. 2 of them being Courses and Disciplines. Courses table has got discipline ID but Discipline table doesn't…
Context: I've been creating a database for a class assignment, the assignment doesn't have detailed instructions, instead gives us a narrative in order to have us make our own assumptions and interpretations as to what to create for the database.…
I keep running into this one over and over again, and seeking if there is a better (much more optimized) way to achieve this. Requirement : From a table XYZ select a random n rows (n can be one or…