How to loop through an array in SQL where clause? – Mysql
I have a MySQL table which has the following columns and records: | Name | Total | GivenBy | | ---- | -------- | ------------ | | Z | 200 |['A','B','C'] | | X | 240 |['A','D','C'] | I would…
passing a Datetime from SQL to an asp textbox but getting different result – Asp.net
I am passing a DateTime value from SQL Table to a Textbox in ASP.Net using <asp:TextBox ID="dateTxt" runat="server" Text='<%# Eval("date").ToString()%>' class="form-control"></asp:TextBox> The Value in SQL is 2023-02-08 16:01:49.153 But shows in the textbox as 2/8/2023 09:07:13 PM I want it…
Use a CASE expression without typing matched conditions manually using PostgreSQL
I have a long and wide list, the following table is just an example. Table structure might look a bit horrible using SQL, but I was wondering whether there's a way to extract IDs' price using CASE expression without typing…
Executing raw SQL in migrations: keep SQL statements as strings inside a migration or as code inside a separate SQL file? – Postgresql
In the database, I have multiple materialized views with big definitions. I also have multiple migrations that change the definitions of some of these materialized views using DROP and CREATE statements. Thus, we often are dropping / recreating the same…
calculate 2 cumulative sums for 2 different groups – Postgresql
i have a table that looks like this: id position value 5 senior 10000 6 senior 20000 8 senior 30000 9 junior 5000 4 junior 7000 3 junior 10000 It is sorted by position and value (asc) already. I want…
use AS in mysql to select a name from another column on the table
I need to select a value from a column in the table as a name of the another column in mysql for ex :: select column AS (select column from table where id = 1) from table; it give me…
Add row base on condition of another column using Postgresql
I have a table and I want to add some rows based on column 'days'. And for each of those rows, the 'Date' column will increment by 1 day. For example: Table X: Date Group days 1/1/2023 A 3 5/1/2023…
PL/pgSQL select statement inside trigger returns null using where NEW – Postgresql
i'm creating a trigger that triggers on INSERT on a table, and i wish to log the structure of tables inserted so i wrote this Function CREATE OR REPLACE FUNCTION update_table_log_received() RETURNS TRIGGER AS $$ DECLARE added_column TEXT; target_table_name TEXT;…
Eliminate the duplicate rows from the table in SQL – Mysql
I want to eliminate the duplicate rows based on email from the table and retrieve all the rows without duplicates. I have tried using distinct but I'm not getting desired results. SELECT DISTINCT Email FROM Users Example Table: Id Email…
Posgresql LAG with condition – Postgresql
My data looks like this: id user data date 1 1 1 2023-02-05 2 2 1 2023-02-05 3 1 2 2023-02-06 4 1 3 2023-02-07 5 2 5 2023-02-07 I want to get a difference between data of each row…