I’m currently stuck with MySQL I would love to make this SQL to use the COUNT for each id_customer that was GROUP BYed as well. Picture of result And now it takes COUNT for every id_customer so it divides everything by 6 instead of 3 for id_customer 3, 2 for id_customer 1 and 1 for id_customer 66. Help …
Tag: sql
How to change arrays into rows
There is a table in BigQuery that contains 2 REPEATED(arrays) type of columns, enterded_date and status. Table in BigQuery: Is it possible to make a query that returns rows instead? Like this: Answer Consider below approach if applied to sample data in your question – output is
How to move ID of duplicate names to a separate column
I have a MySQL table with two duplicate names, how can I separate the IDs of the duplicate names into a separate column? For example, like this: This is my current SQL statement to retrieve the current results in the first table: There is only one duplicate at most for each name. Thanks Answer If you are sure…
How to extract attribute value from XML in SQL Server 2019 (v15)?
I would need to extract elements from this XML into a tabular form, but I can’t seem to get my head around how this would work on SQL Server via something like XQuery. I have all the data in a temporary table called “#1” and the XML itself lies in a field called “Message” in that…
How do I add text to a column that already has text in it in SQL (I want to add the new text to the end of the text that is currently stored)
I have already looked at the answers on How can I add text to SQL Column. However, I am not sure how to add the text I want to the end of the text that is already stored in the column. Can anyone help? I am using SQL Answer In supported versions of SQL Server you can employ one of
Select from select using Laravel eloquent
I want to get all user’s favourite products. The query should be like this: How can I query with eloquent? Answer You’re trying to achieve something like this: In the oficial documentation you can find the explanation of Advanced where clauses The final result will be (you can see this dumping the…
update rows using inner join posgresql
I have 2 tables users and countries, and i’m trying to set the country.name with users.country_name for all countries with null name. Schema : Ref: U.country_code > countries.code QUERY Error : DBSQLException: SQL Error [42P01] Answer Follow the correct update join syntax and also remove the alias fr…
Is it possible to delete last n records of a django model in one/minimum database query?
I’m trying to delete last 10 records of Task table/model in django but I’m unable to do that in one query. Above code gives me error AttributeError : ‘list’ object has no attribute ‘delete’. If I make a loop and then use .delete() on each object of that list then it will ca…
Why is the return type of sysdate DATE? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 9 months ago. Improve this question Sysdate returns the current system date and time and its return type…
INSERT and SELECT on the same table in one SQL statement
I have the following SQL query : MySQL is complaining with the following error: Is there a way to achieve this without spliting the SQL statment into 2 ?! Answer