While updating my TYPO3 project from v7 to v10, I encountered some difficulties with my custom extensions. Due to that I just tried to rebuild the demo extension from the official TYPO3 website: https://docs.typo3.org/m/typo3/book-extbasefluid/10.4/en-us/4-FirstExtension/2-create-folder-structure-and-configur…
Tag: sql
get top values in select
I have next ordered table: types count soft 7 lite soft 5 middle soft 4 hard soft 3 other 2 I need to select top values, sum of witch is 15+ (in my case 7+5+4 > 15) …
Invalid Number ORA-01722
I have problem in my query that I always get this kind of error ORA-01722: invalid number Whatever I try to doesn’t work. The query is here SELECT * FROM ( SELECT p….
merge values in select
I have next part of query: SELECT types, count FROM … Result is next: types count soft 3 lite soft 2 middle soft 7 hard soft 2 other 5 what I need is to merge results …
Combining sql queries together
I am trying to simplify my current query code. Is there a simpler way of combining both queries into one? Here is what I have tried so far. Although it seems really messy and clunky. This query …
Why were all rows deleted when trying to delete old rows with date query
I have a table with column name date of type timestamp I’m trying to delete old rows with the following query: delete from my_table where date<(now()-'30 days'::interval) but all rows are deleted. …
Get Ids of rows that has duplicates in a column
I have the following table users id | phone ————– 1 | +1111 2 | +2222 3 | +3333 4 | +4444 5 | +1111 I need to get all ids, where users have duplicate phone. For …
How can I find duplicate records in clickhouse [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I want to know how I can find duplicate data entries within one table in clickhouse. I am act…
SQL PIVOT-WINDOW FUNCTIONS
With the sql query I get table 1 table 1 Trying to pivot using window functions below on Server 2012 fails My desired output Answer Use conditional aggregation Also, you can try with pivot –
sql- suppressing the amount value to get the unique value when its multiple rows of same information
Sorry for the confused title. I am on Teradata 16.1, I have two tables, one is a simple table with id and amount and another one is a detailed table with sub id’s and their amounts. In the second …