I have a users table like this: I would like to display a query, where every user is listed twice with different text (created_at / updated_at) and the date. The merged query should be ordered by date (created_at and updated_at).…
I'm using Laravel 8. I would like to have a query, where all items from the users table are listed twice, one with created_at column, and second with updated_at column. The result of this array should be in an ascending…
i just started my journey with SQL, and made some tables of Cyclists, and Cycling Teams. Cyclist's table contains columns: ID, Name, Team (which is foreign key of TEAMS ID) Team's table contains columns: ID, Name, Number of Cyclists I…
I'm having a lot of difficulty writing an SQL query. I need to compute the difference between consecutive rows for 4 different regions across different years, then subsequently display only the top 3 regions with the highest count of negative…
The below query finds one id by using the below query format but it seems I have indexed all columns, but it took time to execute between 54.3 seconds - 1.2 mins. What can I try next? Query: select op.ord_prod_id…
I am doing autocomplete query system for cities and I have problem, that I want to prioritize main city of region from another results showed for exact phrase for ex. "%Trenc%". |id| city | region | ... |12 | Trenc…
I have a table with close to a billion records, and need to query it with HAVING. It's very slow (about 15 minutes on decent hardware). How to speed it up? SELECT ((mean - 3.0E-4)/(stddev/sqrt(N))) as t, ttest.strategyid, mean, stddev,…
I have that kinda table and data : Table Name : data +------+-----------------+--------+----------+ | id | number | name | surname | +------+-----------------+--------+----------+ | 1 | [1, 2, 3, 4, 5] | John | Doe | | 2 | [1,…
I'm kinda new to programming in general. I'm trying to loop through a table. There is a connection to the DB already. It's giving me - "Object of class IlluminateDatabaseMySqlConnection could not be converted to string" class ProductController extends Controller…
I am making a site in which user uploads it's pdf and back of the site we generate audio file for each page and now we want to save it on the database(mysql). Now the problem starts we have model…