Top "Case-statement" questions

A case statement allows sequences of SQL statements to be selected for execution based on search or comparison criteria, and is typically used in stored procedures.

mysql switch case

I have a query structure like below, Im wondering if there is a way to the write the select queries …

mysql sql case-statement
Conditional value replacement in SQL Server

I have a table that has several columns. The value of one column is 0 or 1. I want to write a …

sql sql-server select if-statement case-statement
PL/SQL Using CASE in WHERE clause

Good day Stackoverflow! I have a query that is giving me an error: "Missing Right Parenthesis", at least, so says …

plsql case-statement
Trying to set a variable inside a case statement.

I'm trying to update a date dimension table from the accounting years table of our ERP System. If I run …

tsql initialization sql-server-2000 case-statement
Verilog Barrel Shifter

I want to create a 64-bit barrel shifter in verilog (rotate right for now). I want to know if there …

rotation verilog bit-shift shift case-statement
Why must you GROUP BY the columns in a CASE statement?

I'm trying to run a query in SQL Server 2008 against a table where some of the data was entered inconsistently …

sql group-by case-statement
How to assign multiple values in CASE statement?

I need to assign two values to my select based on a CASE statement. In pseudo: select userid , case when …

sql sql-server case-statement
case-statement or if-statement efficiency perspective

Possible Duplicates: Is "else if" faster than "switch() case"? What is the relative performance difference of if/else versus switch …

java performance if-statement case-statement
Haskell: Multiple Case Statements in Single Function

I want to include more than one case statement in a Haskell function (see below for an example of a …

haskell case-statement
LIKE operator for Progress DB SQL

I'm trying to do something like this in Progress SQL (THIS IS NOT POSTGRES!) SELECT CASE WHEN code LIKE '%…

sql sql-like case-statement openedge progress-db