I have an API in my C# WEBApi project which return some items from my MySQL DB. The data to return has a visibility set in a table and the params set in the API call says which kind of data should be …
Tag: sql
How to use conditions with a RANK statement
The following piece of code does its job : it gives me the top 10 results for each category. SELECT * FROM ( SELECT *, RANK() OVER (PARTITION BY “pera_id” ORDER BY “surface” DESC) …
SQL Complex update query filter distinct values only
I have 3 tables with following columns. Table: A with column: newColumnTyp1, typ2 Table: B with column: typ2, tableC_id_fk Table: C with column: id, typ1 I wanted to update values in A.newColumnTyp1 …
group by date and two different times in the same date in Sql
i want to select from my database the data that is BETWEEN to date and two different times in the same date but when I use the Sum in one of the variants it give me a wrong result i thnik that the …
How to tokenize semicolon separated column value to pass to IF statement in a function in Oracle DB
I have a table called ‘config’ and when I query it in following manner: SELECT value FROM config WHERE property = ‘SPECIAL_STORE_ID’ its response will be: 59216;131205;76707;167206 //… (1) I want to tokenize the above values using semicolon as the delimiter and then use them in a…
query to insert records to another table by calculating the percentage on a column
I have 2 Postgres tables with the following structure: Lets say I have data in the tmp table as below: I have a script below that inserts the data from public.tmp to public.mo table based on the criteria that if the column STATUS has mix values (COMPLIANT and NC) for a particular HOSTNAME then compliant_statu…
SQL Server select query based on logic
I have the below table : ID Package 1 T 1 E 1 B 1 F 2 E 3 E 3 F 4 F 5 B 5 F I need the below output table : ID Package 1 T 2 E 3 E 4 F 5 B Priority list for the …
Delete row in datagridview and database with C#
I made a database and a program with a datagridview to show the database content. Now I want to make a button to let users delete a row and delete it also in the database. I tried the following …
How can I calculate a percentage from values obtained by 2 different queries in SSMS?
First query: select COUNT(EUpdate) from EmpUpdates where EProj = ‘abc’ and EID = ‘101’; Second query: select COUNT(EProj) from EmpUpdates where EID = ‘101’; percentage = (first query / second …
python list in tuple compare
I have a list and a tuple ( from sqlite query) and what to check if the items in list are not in the db tuple. If not add to newJobs list links = [“example.com”, “mysite.com”] …