So, I am trying to create a query that counts the numbers of Redirects per week per Site. I made the below query which gives me almost the correct results, but if there are no Redirects, there are no count…
If I have a table Application_user with 100 columns, what is the performance difference between two queries: Query 1: select * from Application_user; Query 2: select a.col1.a.col2,a.col3........ from Application_user a; Performance difference between two queries. And reason behind it
I am trying to figure out what would be the most efficient way of achieving the following: I have two tables: word_translations(id, word_id, language_id) and translations(id, text, word_translation_id, created_at, updated_at, user_id) So there is a one-to-many relationship between word_translations and…
Here is a question concerning a basic DB query in PostGres. I have two tables created as follow: => create table Prix (rank integer primary key, value bigint unique); CREATE TABLE => create table Pris (rank integer primary key, value…
I am trying to parse this sql query using spring data jpa to use in my application. It is a postgresql qurey using some of the geospatial functions using postgis. This query is basically trying to find all the records…
I have two simple queries below: SELECT * from table_name where status IN (0, 1, 2, 3, 4) SELECT * from table_name where status NOT IN (5, 6) The possible value of status is 0 to 6, and column status…
I have an entity that has, among other things, two jsonb columns : "options" and "features". I want to copy data from a field inside the options column to a two levels deep field inside features. What I've tried :…
I have two tables, one is products and the other is varients. In product table I store product basic data such as name, image, brand, etc. In varients table I store variants of product such as 1kg, 2kg, 5kg, etc…
I'm trying to create a summary report of sales per year with a couple of tables like the following: products id (PK) [... ] Orders id (PK) date product_id (FK to products I've written a query where I select from…
Working with PHP and SQL here. I have a bridging table in my database that has columns with separate options (option 1, option 2, etc) and another table with the information of each option. This is because the result may…