Questions tagged [case]

Question 1

Problem I am well aware that SQL is a declarative language and does not enforce short-circuiting. Oracle, on the other hand, explicitly states that short-circuiting takes place for CASE statements. I ...

Question 2

I have a query which has multiple joins and need case statements for multiple columns to get the correct data. Although I can manage to get the data, it creates a lot of duplicate rows. Seems like 1 ...

Question 3

I am trying to write a regex that can replace '[', ']' and '].' with '_' and in cases where ']' is the last character it should be replaced with '' but I am struggling to come up with a regex for it ...

Question 4

Does anyone know the file name or path where I can change the lower_case_tables_names value on the latest version of MySQL Windows 11?

Question 5

I have 2 tables, size and cost. My query does a count with a greater than comparison of cost and counts different sizes. table1: size u table2: cred t Here is my query: select u.size as size ,...

Question 6

When I use my query to select all data from the table I have a problem with the custnumber field. If custnumber is returned within the same month then it should group the results but only then. This ...

Question 7

Say I have below table cis aid cid apid ntime buid flg jid 30 1208 229067737 1026 9 DDDD400C 0 0 30 1209 229067737 1026 11 DDDD400C 0 0 30 0 229067737 1026 12 DDDD400C 1 100 30 1210 229067737 1026 13 ...

Question 8

I have two tables: EVENTS ID Name 1 First event 2 Second event 3 Third event 4 Fourth event 5 Fifth event EVENTS_META ID EventID MetaKey MetaValue 1 2 date_expired 2023-02-09 00:00:00 2 2 date_expired ...

Question 9

SQL Case When - I have a column with job status options B & D. I want to create a case when SQL statement that will check and retrieve employee IDs with both statuses in the column. In thise case ...

Question 10

I have the following case statement case %1$s::text when ''lookup_relation_job'' then case %1$s.relation when ''followers'' then ''get-followers'' when ''following'' then ''get-...

Question 11

I have part of a string that I would like to remove when selecting. The Problem is that there are a few pieces within the string that changes. This is what I have so far. Select GROUP_CONCAT(...

Question 12

I am trying to return multiple columns only if a condition matches, else, return something else. Using Sqlite3, my understanding is that the way to do this is using CASE, so something like this: ...

Question 13

I'm trying to write a case expression where it looks at the due date and if it has passed chooses the upcoming or closest due date. Now due to certain database restriction I have to do this manually. ...

Question 14

I need some logic help with a complex join situation. Here is an overall idea of the 3 tables I am working with Table 1: ID Number Type 1 A1 A2 Table 2: ID Number Type 1 ID Number Type 2 A1 B1 A1 B2 ...

Question 15

I have four tables like this: company: id companyContactID customerID companyTeamID 1 12 21 54 2 14 12 78 document_associated_company: id companyID documentID 1 2 98 2 1 12 document id documentTypeID ...

Stack Exchange Network

Questions tagged [case]

Oracle Violates Short-circuit in CASE Statement

How to Avoid Duplicates with multiple joins and multiple case statements

Regex help in Snowflake

MySQL case sensitivity setting

Comparing 2 count columns with case

how to GROUP BY so that not all results are grouped

Set variable on multiple case within each group

MySQL - multiple CASE ordering with joined table

SQL multiple condition case when

Problem with case statement and dynamic table name

Replacing Part of a string within a group Concat

How to conditionally return multiple different columns in sqlite?

Limit my ticker count to maximum 12 Months

SQL Server: left join resulting in multiple rows, want each row result in separate column in result

How to use a JOIN inside a CASE expression?

Hot Network Questions