Posts by Feitosafelipe • 59 points
5 posts
-
2
votes2
answers505
viewsQ: Count in recursive function
I need to count how many times a comparison is true within a recursive function, but I don’t know how to do it, because any counting variable will be reset when starting the code. def…
-
0
votes1
answer30
viewsQ: Query with a different filter for each line
I’m doing a query where, I have 3 columns related by a text filter Where '.' Like %xxx%', where each row of the column has a different filter (a Like %xxx% different). I tried to mount cases but I…
sqlasked Feitosafelipe 59 -
0
votes2
answers79
viewsQ: Do an SQL sub-query
I am trying to make several queries (counting the amount of certain elements) within the same table column, and send each query to a different column. Ex: I have column of names, and I want to…
sqlasked Feitosafelipe 59 -
-1
votes1
answer48
viewsQ: Make SELECT return only a snippet of the string
I need to make a query that only brings an excerpt of the string. I thought about using the SUBSTR() function but could not. Ex: column being something like [abcd efg hig; efg hig abcd; jkl juh hig]…
sqlasked Feitosafelipe 59 -
0
votes4
answers2542
viewsQ: Access list element within Python list
I have two lists within a list and each index of the list contains an ordered pair, in this way: [[2, 5], [3, 6], ..., [x, f(x)]]. I want to know how to access a specific item of one of the lists,…