I am facing a problem with a SQL query, which takes around 500ms when queried using RAW SQL (retrieve all data without limit). However, using the same query in laravel(tried Eloquent, DB builder and RAW) it takes around 15 seconds…
I'm getting data from the posts table and there is a likes table that is related to this. I want to know how many likes each post has. I followed an example, but this way it gives an error. I…
I have DB with 4 tables. I have to use 3 of them. Is it possible to change LEFT JOIN statements with only WHERE statement? Database scheme My code block with LEFT JOIN statements: FROM reader LEFT JOIN copy ON…
My subquery = select *,rank() over(partition by city order by hourly_pay desc) from persons as a; My whole query = select * from ( select *,rank() over(partition by city order by hourly_pay desc) from persons ) as b where rank=1;…
Let's assume below table orders_daily_data in which we store number of orders made for a given product across the time: ID ProductType Orders OrderDate 1 sugar 5 2023-01-04 2 flour 0 2023-01-04 3 pepper 7 2023-01-04 4 sugar 1 2023-01-05…
I have 3 tables: conversations participants contacts participants is many to many between conversations and contacts. It has contact_id, and conversation_id. I want to write a select query that takes one or more contact_id values and returns a record from…
I am learning SQL and have created the following dataset in MySQL: Create table Departments (DepartmentID int primary key, Name text); insert into Departments values (1001,'SRO'), (2001,'Drs'), (3001,'Accounting'); Create table Employees ( EmployeeID int not null, DepartmentID int not null,…
I have a table where we have partners and orders are set. |partner_id|order_id| | -------- | ------ | |1 |5 | |1 |6 | |2 |7 | |4 |8 | |4 |9 | |4 |10 | Here we have a…
My objective is to make Postgres choose a faster plan after a large table update. Before the table update, the plan PG choose is what I expect (the faster plan). However, after the update, PG chooses a slower plan (it…
[TABLE 1] shop_name whole_sales_amount A 20000 B 40000 [TABLE 2] shop_name locataion representative_number A NY 1234 A LA 1234 B IL 5678 I want to join Table 1 & Table 2 (I know that the DB table structure is not…