I have two tables cities (as C) and routes (as R) C: ____ ______ | id | city | |____|______| | 1 | A | | 2 | B | |____|______| R: ____ ______ ____ __________ | id | from | to | distance |…
UPDATE with INNER JOIN on SQL Server
I have 2 tables Users and Orders. Primary key of Users is UserId, which I have defined as foreign key in the Orders table. I have added a new column of UserName to Orders. I want to import UserName …
SQL group by is bringing lots of duplicates
I’m trying to group my data by OccDate, ParkingContextType, AuthorityId and of course, i would like to measure each sessions for each date/contexttype etc… However, I`m also trying to calculate the …
How to know the size of a table with a photo in Oracle
I have a table that I fill in the post method, I send a photo, and describe the event, I want to know the size of this table (MB) with the help of a selector, Someone can help me with this ?? SQL> …
how to return a unique set of characters within a field (SQL)?
Basically i am trying to return any fields within the tag column that contain up_ up1_ up2_ up3, up4_. the problem i’m facing is i only want to show these tags and not the others. The field …
Access SQL: Update list with Max() and Min() values not possible
I’ve a list of dates: list_of_dates. I want to find the max and min values of each number with this code (#1). It works how it should, and therefore I get the table MinMax Now I want to update a …
SQL – a member can see a doctor only once a year
I have a table named Claim. I have built the following query except the last column(Reimburse). How do I populate Reimburse column like this table? So the idea is that company pays a member to see a …
how can I make this query not CaSeSeNsITIVe?
how can I make this query not Case sensitive? @courses = Course.where(‘name LIKE ?’, “%#{params[:name]}%”)
How to implement BETWEEN Sql query in Firebase?
I am working on a android Firebase project. I need help in implementing this sql query in Firebase real-time database. Answer There’s good documentation on how to do firebase queries as well as apply them to ranges. Something like: Then you add the appropriate listener for what you are trying to do. (e.…
DB2 NVL with empty string
As in DB2, empty string and null are unlike in Oracle. Is there any method to realize NVL but with empty string？