can anyone help me with this query? is it possible to do something like this? I am very new to sql. table1 'userJobId' have 2 coloumn userid and jobgroupid, table2 'tbl14userJob' have a14userID and a14jobID as coloumn. I need to…
I'm trying to change the format of time_discrep (below) into a fraction of days. Code: select time1, time2, (time1-time2) as time_discrep from main_file order by time1; Screenshot of results: I've tried dividing, etc, but it just formats it like 00:00:32…
I want to join columns from several tables. For one table join works fine select org.catalog_truck.plate_number as "Госномер грузовика", shift_id as "ID смены", trip_id as "ID рейса", * from core.monitoring_stages join org.catalog_truck on vehicle_id = org.catalog_truck.catalog_truck_id where gen_id = (SELECT…
I have a table invitations keeping for each user the email invitations he received. One user can have many emails, on each email can be received many invitations. create table invitation ( user_id INT NOT NULL, email VARCHAR(32) NOT NULL…
I have a SQL query when joining several large tables. My database consists of millions of rows across the users, orders and transactions table. Here is the query SELECT u.name, COUNT(o.id) AS order_count FROM users u JOIN orders o ON…
My system is using PostgreSQL as the database. I am encountering an issue when using a query to join two large tables together. I'll briefly describe the tables as follows: Location: - id: uuid - name: string (indexes) - country:…
i need to get concurrent sessions for every minute of day from database with ~2 million rows. what is the best(fastest) way to get that data? table contains session_id, session_start_time, session_end_time example CREATE TABLE `session_id_table` ( `session_id` bigint NOT NULL,…
I have a table similar to this, where I need to pull the value out of each JSON field that has an id equal to 2. I've tried multiple examples, but cannot manage to wrap my head around how to…
I'm working on a NestJS application with TypeORM and PostgreSQL, and I need to fetch a list of users sorted by the timestamp of the last message they sent. I have two entities, User and Message, defined as follows: user.entity.ts…
I have two tables: table_a and table_b. Size-wise, table_b is much bigger than table_a. There are fields(names) that are present in both the tables. The goal is to find the names (or the number of names when using count): that…