I have a table which in which I would like to generate random numbers in a specific format (e.g. TEST-10256). For which I have been using the below: However I now want to update a table with these random numbers based on two columns, so the desired outcome would be this: I am not sure how to keep the same
Tag: concatenation
Remove subset rows of other rows in SQL
I’ve this table below that includes ID, and five indicator columns: x1, …, x5: I need to remove duplicates based on this logic: For each ID, we look at the values of x1, …, x5, and we remove the ones that are subset of other row. For example, for ID=1, row #3 is a subset of row #2, so we
MYSQL how to merge rows with same field id into a single row
I have a select statement with rows as table_Schema I need to merge the rows such that blogs with same row id are merged into a single row. I am trying to get either <author fname, author mname, author lname | coauthor fname coauthor lname> or a column as author co author Each blog can have multiple aut…
How to add all text in a column into one cell in Snowflake
So I have data as follows: All I would like to do is make a new table which gathers all text into one cell as follows: So all values of tags are in one cell for each ID. Order does not matter, but they must be separated by commas. Answer how about this :
How to concatenate two different values from two different columns with comma ” , ” using TSQL?
I would like to know how to concatenate two different values from two different columns from a SQL table using TSQL ? As you can see, I would like to concatenate those two different columns X e Y, resulting in the follow column table: Which query should be used here ? Answer You can use concat as
How to concatenate a conditional field and remove the same value
I am trying to create a column with a case statement, then concatenate the column. Here is an example code. Basically, the Action_with_no_date will display the concatenation of values in Action with ‘**’ string added to the values where Date is null for each ID After I did this, I found an edge ca…
bigquery transpose and concatenate for each record
I want to achieve the following transformation. I have last_name stored in a repeated record as follows. data before transformation I want to achieve the following. data after transformation Example with sample data created. I’m not sure either if I should store it as an array instead of a concatenated …
SQL query to CONCAT/list unique column data if rows have identical data in the other columns?
Thanks in advance. I’m basically trying to run a SQL query so that the results are 1:1:1:1:Many for StaffID:Name:Floor:Date:Shifts. Here is my initial query and example results: I then combined the ShiftStart and ShiftEnd columns with the following to get the further below results: What I can’t fi…
Combine cells in access separated by comma
I am new to access and coding. I have a sheet comprising of huge data. I want some specified data in Access by running a query or VBA. What I want is to combine the data based on a column and each data separated by a comma. I am pasting the example of the sheet below: Input sheet Output data
Concatenate from rows in SQL server
I want to concatenate from multiple rows Table: |id |Attribute |Value | |——–|————|———| |101 |Manager |Rudolf | |101 |Account |456 | |101 |Code |B | |102 |Manager |Anna | |102 |Cardno |123 | |102 |Code |B | |102 |Code |C | The result I’m looking for i…