Suppose I want to keep who follows who in a simple table that has two fields ; UserId and FollowedId and I have a simple data set like ; UserId FollowedId 1 100 2 100 3 100 4 100 5…
Table "Observation" is filled with records, that come from table "Result" (observation_id = result_id) In table "Observation" every record has a corresponding record that is also in the same table. Is there a way to link those two records, giving…
so i have this tables with their own attributes BOOK TABLE BOOKSHELF TABLE STORE TABLE LOCATION TABLE id_book id_bookshelf id_store id_location name name_bookshelf name_store name_location author id_store id_location id_bookshelf And i wanna show this kind of table TABLE_EXAMPLE id_store name_store…
This the example of the table name is merchant_point_log : id created_date merchant_id point_value recent_point status 1 2022-01-02 1 5000 5000 earn 2 2022-01-02 2 3000 3000 earn 3 2022-01-02 1 3000 3000 redeem i would like to show logging…
I've got a brand new SQL database inside my new Azure server and I want to allow access to some users that I have designated with the 'Contributor' role, so they can write some SQL code. However, they cannot authenticate:…
In Postgres, when a table owner, say "xxx" tries to transfer the table ownership to user "yyy", he is getting error ERROR: must be member of role "yyy" When I searched further, it can be fixed in two ways. As…
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…
I'm trying to validate my checkbox from a loop, where at least one is checked and displays an error/alert or disable the submit button instead if there is no checkbox checked. I tried putting a required method inside my checkbox,…
Simplified the following question I got from a coding challenge... I have a table grades like: year sex person mark 2000 M Mark 70 2010 F Alyssa 23 2020 M Robert 54 I want to select the people per year…
I'm working on a CTE (probably not relevant), and I have two possible inner joins, but the second one should only be used if the first one is empty (it could be used anyway, in fact, IT MUST be executed…