I have 3 tabels (Files,Users,Files_Users) Files Table A Id File Name 1 A 2 B 3 C 4 D 5 E Users Table B Id User Name is_internal is_external 1 Adam 1 1 2 john 1 0 3 Caren 0 1 Files_Users tabel Id File_Id Int_User_Id Ext_User_Id 1 1 1 1 2 2 2 1… Read More what the SQL function that can solve my query

Is there a limit to the maximum number of values we can have in the in clause sql_query = """SELECT * FROM table1 WHERE column1 IN %(list_of_values)s ORDER BY CASE WHEN column2 LIKE ‘a%’ THEN 1 WHEN column2 LIKE ‘b%’ THEN 2 WHEN column2 LIKE ‘c%’ THEN 3 ELSE 99 END;""" params = {‘list_of_values’: list_of_values}… Read More Maximum value we can have in in clause

I’m having results I don’t understand from a MySQL query that should be pretty simple. The goal I want to achieve is more complex, but I have reduced the problem to this: When I am using NOT IN subquery in a WHERE clause, it even removes lines that are not included in the subquery. In… Read More MySQL NOT IN subquery removing more lines that contained in the subquery

I have the following request : SELECT column1, column2, SUM(column3) as total FROM my_table GROUP BY GROUPING SETS ((column1, column2), ()) Which returns : Name1 Name2 QTT AB CD 15 ZE EF 15 None None 30 So |None|None|30 is the output from the GROUPING BY SETS But I am wondering how to define the first… Read More How to set the first column value of a GROUPING SETS

I have the following: SELECT [Sales_Line_Item].[Sales Date], [Sales_Line_Item].[Quantity]*[Sales_Line_Item].[Unit Price] AS [Total Sales] FROM Sales_Line_Item WHERE [Sales Date] = #9/1/2020#; Which displays: I want to add the total sales together so that the result is: Sales Date Total Sales 9/1/2020 $6,276.00 Thank you for any help I wanted to use SUM(Total Sales) someway but I’m missing… Read More Brand new to SQL, looking to find total sales on a specific day

I Apologize, but I have exposed my question to google_and_ChatGPT. I Think a need a … human. Is my question so hard ? To me, yes. I have two colums in a Table in a SQL Server database. I have checked that (int)Logicial_Value stays into [0;2] by Logical_Value BETWEEN 0 AND 2 I need to… Read More Where is my syntax error in this SQL CHECK CONSTRAINT?

i am currently practicing my SQL skills. I wanted to get all data in the past 1 minutes. The query is SELECT * FROM menfesses WHERE created_at >= NOW() – INTERVAL 1 MINUTE; But somehow, it returns all data. I have also use date_add approach and nothing works What did i do wrong? Thanks >Solution… Read More SQL Select data in the last 1 minutes

with unmatchedTranCounts as ( select ‘rms.ordhead’ as tableName, count_big(etl_update_ts) as todayRows from rms.ordhead t1 where t1.etl_update_ts >= convert(date, getutcdate()) union all select ‘rms.shipment’ as tableName, count_big(etl_update_ts) as todayRows from rms.shipment t2 where t2.etl_update_ts >=convert(date, getutcdate()) union all select ‘rms.shipsku’ as tableName, count_big(etl_update_ts) as todayRows from rms.shipsku t3 where t3.etl_update_ts >= convert(date, getutcdate()) union all select… Read More Could you please help me to find the error in my below sql code

On a project where we have SQL tables called Products and Conditions, we want to determine which product belongs to which most matching condition, because a product can belong to multiple conditions. Is there a way to do this in C# or SQL? Below you can find a shorted version of the tables with the… Read More C# / SQL Determine matching score based on properties

i have two tables NAMES and NAMES_VERIFICATIONS NAMES id fname Tax 1 jack 56982 1000 Tim 32165 2321 Andrew 98956 231 Jim 11215 NAMES_VERIFICATIONS id idtype iddata 1 tax 56982 1 passport 12365 2321 tax 98956 2321 passport 65656 so if you notice there is no ID 1000 in the NAMES_VERIFICATIONS table so i want… Read More joining two tables eventhough the id does not display on the second table