Posts by unkbr • 45 points
4 posts
-
1
votes1
answer82
viewsQ: how to take a substring of size n that repeats
I have the following entry: aaisndiaunwioun test|test saiudb8iuyb aiwbu diby tab fiubaw palavragrande|palavragrande asibtiubi How to make the algorithm return test and palavragrande only if it’s…
-
0
votes0
answers36
viewsQ: delete the records that repeat in the entire table minus 1 column
I have the following data: note that there are some Ids that contain more than 1 record, would like to delete the repeated record whose value is the lowest among the repeated ones the table may have…
-
1
votes2
answers763
viewsQ: select multiple columns group by 1 column
I have a table with 300 thousand records and within it there are several different fields, I would like to take the line that contains the largest OUTGOING DATE calculated for each CPF_1 what I…
-
2
votes1
answer746
viewsQ: split 1 column into 2 in sql server giving update
I use SQL Server 2012 I have the following problem, in a table there are records of municipalities and two respective Fus but there is the need to divide this column into 2 one of municipality and…