SQL – Page 1128 – SQL Questions Answer

sqlalchemy concat with more than 2 elements on Oracle DB

concat oracle python sql sqlalchemy

considering the following table definition I create a select-statement using the sqlalchemy.sql.functions.concat with 3 statements using the query is generated. However, when I run this, the exception ORA-00909: invalid number of arguments is thrown. This is because CONCAT (https://docs.oracle.com/cd/B19306_0…

Getting Msg 8623, Level 16, State 1, Line 1 error on a simple select query on one table

sql sql-in sql-server subquery tsql

How to optimize a simple query that search on one table for IDes that are not a part of a set. I created the following query Be aware that the list includes bit more than 35000 rows. I get the following database error Msg 8623, Level 16, State 1, Line 1 The query processor ran out of internal resources and

SQL subquery for function count

The first column is the name of the locality,the second column is the number of voters in every locality.. my problem is on the third column because im trying to count voters that are unemployment but …

SQL WHERE look for 2 data in one column

I got 2 tables item: name id other part: name_part id other I wish to make a query to find what item is linked with name_part = ‘a’ AND name_part = ‘b’ 2 different parts in a same item Query: …

SQL Group By, case when on aggregated

Can’t wrap my mind around the next task: I have a table, with some key, which represents some kind of group id. I would like to GROUP BY by this key and in resulted table show some columns from this …

Find all recipes with just vegan products

I have been trying to find all recipes with just vegan products but so far I just have this: SELECT DISTINCT r.* FROM recipes r INNER JOIN recipe_product rp ON r.id = rp.recipe_id INNER JOIN products …

Generate a triangle of stars using mySQL recursive CTE

I’m trying to generate a triangle of stars in MYSQL that looks like this: ***** **** *** ** * I’m using the following code to do in MYSQL with recursive print_star(n) as ( select ‘*’ UNION …

Python SQL script inserts only the last row of the dataframe to SQL Server [pyodbc]

pandas pyodbc python sql sql-server

I am trying to import a pandas dataframe to Microsoft SQL Server. Even though, the command is correct and executed successfully, when I select the first 1000 rows of the table in SQL server only the …

mysql get ranking position grouped with joined table

I have two tables, the first is players ——————————————— | player_id | player_score | player_game_id | ——————————————— | 1 | 274 &#…