Tag: sql

getting different results from the same query according to the value of a variable

oracle sql stored-procedures where-clause

suppose we have the following masterdata: and we have the order tables: what is requested is to have one single query that could return 2 different sets of data, according to the value of a given variable v_order_status: v_order_status = ‘del’ then only transport orders is retrieved: v_order_statu…

Why do I need to declare variables twice: within and without the dynamic query?

azure-data-studio sql

I’m reworking an existing static query to be dynamic. Why am I needing to declare the variables twice? Once at the top of the file (for a subsequent, unchanging query) and again within the dynamic …

how to combine multiple rows into one row?

mysql pivot-table sql

My table: What i want to get is: Is there any simple way for this? Answer If you are using MySQL 8+, then ROW_NUMBER combined with pivoting logic provides one way:

Combining MAX and SUM in an Oracle ROLLUP

oracle oracle12c sql

Here’s my SQL: The output looks like this: I was expecting it to look like this: In other words, I was expecting the rollup to sum up the maximum weights of each food instead of taking the maximum of all the maximums in the food-type category. I do have a solution of sorts, but it means having to add an

SQL connection string is not recognised and throws and exception in C#

asp.net c# sql sql-server wpf

CONTEXT: I am writing a WPF app. It works with a SQL Server database in which I put some data, concretely the strings Titulo and Descripcion, the int XP and the string fotoMision. When I click a …

Add Sequential Letter column to table

postgresql sql

In C I can switch between int and char to build a list of sequential integers and then convert them to ASCII characters that will be sequential according to the alphabet. Is there a way to do this in …

Query to modify where clause to specify relation

sql

I have 2 tables: users & user_roles users: id name 1 John 2 Doe user_roles: user_id role 1 admin 1 finance 1 accounting 2 admin 2 finance 2 admin I want to get the users that have admin & finance roles in the output(with distinct). So the result will be only user with ID of 2 (Doe) What is the