Most voted "when" questions
9 questions
Sort by count of
-
2
votes2
answers81
viewsHow to use the LESS "when" operator?
I quickly searched the site of Less to see how it is used, but I was not successful, so I wanted to know how the operator works when less!? Examples: box-shadow(@style, @c) when (iscolor(@c)) {…
-
2
votes1
answer64
viewsGroup result through a conditional
I wonder if in Mysql or any other Bank you have the possibility to use GROUP BY with a conditional. I will try to explain I have a status column that can have the value true and false, would like to…
-
2
votes1
answer147
viewsGroup empty case when sql cells
I am making a query in the database to know in which branch the customer paid a installment and what is the normal value and interest that were paid. The value of the tranche is transaction 3 at the…
-
2
votes1
answer68
viewsCase/when, help us
I did a search and I couldn’t find a logic to use in this case. the table columns are: COD_DO_USUARIO_ONE | COD_DO_USUARIO_TWO | TEXT I’m basically trying to put together a code that can identify…
-
1
votes2
answers1006
viewsISNULL in a Case When
I’m making a select using the CASE WHEN in Sql Server, so that the existence of a record is checked, if it exists, it selects in a table, otherwise it selects in another table, but the two can…
-
1
votes1
answer433
viewsIs there any way to use logical operators with CASE/WHEN?
I am trying to use logical operators with CASE/WHEN in SQL but I am having difficulties, I need to present an answer if the result of the operation is less than 0 and another result for when the…
-
1
votes1
answer90
viewsUsing Case or if
I’m a beginner in SQL and I’m having difficulty using the CASE WHEN. I have a table called CRM_PROCESSO, in which you have a column with the option of Status, but the answer to this status is…
-
0
votes0
answers964
viewsCase nestled inside another case
I’m very doubtful about CASE NESTED I have to perform an interest calculation that depends on some variables and I’m not able to build this case, so I need your help to assemble it. 1º IF…
-
-1
votes1
answer179
viewsFilter information from a CASE WHEN SQL and only results that contain all information
I need to return only the result that contains all the information that in the case of this image and the ID='8187' Select d.ID, d.post_title, d.post_type, MIN(CASE WHEN b.name = 'Resinas' THEN…