There are two formats of case expression. You can do CASE
with many WHEN
as;
CASE WHEN Col1 = 1 OR Col3 = 1 THEN 1 WHEN Col1 = 2 THEN 2 ... ELSE 0 END as Qty
Or a Simple CASE
expression
CASE Col1 WHEN 1 THEN 11 WHEN 2 THEN 21 ELSE 13 END
Or CASE
within CASE
as;
CASE WHEN Col1 < 2 THEN CASE Col2 WHEN 'X' THEN 10 ELSE 11 END WHEN Col1 = 2 THEN 2 ... ELSE 0 END as Qty
Related Posts:
- Rename column SQL Server 2008
- Efficiently convert rows to columns in sql server
- T-SQL split string based on delimiter
- SQL Server WITH statement
- SQL Server Insert if not exists
- SQL Server: Invalid Column Name
- How do I do multiple CASE WHEN conditions using SQL Server 2008?
- Arithmetic overflow error converting numeric to data type numeric
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Sql query to insert datetime in SQL Server
- Microsoft OLE DB Provider for SQL Server error ‘80004005’
- Bulk load data conversion error (truncation)
- Can I use multiple “with”?
- Backup a single table with its data from a database in sql server 2008
- How can I group by date time column without taking time into consideration
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- Filter data based on date in sql
- Varchar invalid for Sum operator
- Unknown column in ‘field list’ error on MySQL Update query
- The wait operation timed out. ASP
- When should I use CROSS APPLY over INNER JOIN?
- Insert Data Into Temp Table with Query
- How to create Temp table with SELECT * INTO tempTable FROM CTE Query
- SQL SELECT WHERE field contains words
- T-SQL split string
- Using group by on multiple columns
- Nested select statement in SQL Server
- What’s the difference between VARCHAR and CHAR?
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- How to split the name string in mysql?
- Sql Server equivalent of a COUNTIF aggregate function
- Column name or number of supplied values does not match table definition
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- CREATE VIEW must be the only statement in the batch
- SQL Server FOR EACH Loop
- How can I select the first day of a month in SQL?
- Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- Oracle Apex column link from LOV values
- When to use “ON UPDATE CASCADE”
- How can I delete using INNER JOIN with SQL Server?
- MySQL combine two columns into one column
- ORA-01861: literal does not match format string
- Insert text with single quotes in PostgreSQL
- SQL Server IF NOT EXISTS Usage?
- String or binary data would be truncated. The statement has been terminated
- How to insert date values into table
- Error converting data type varchar to float
- How to concatenate text from multiple rows into a single text string in SQL Server
- Count(*) vs Count(1) – SQL Server
- Remove duplicate rows in MySQL
- I want to use CASE statement to update some records in sql server 2005
- how to remove time from datetime
- “You tried to execute a query that does not include the specified aggregate function”
- How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
- How to round down to nearest integer in MySQL?
- How do I reset a sequence in Oracle?
- MySQL error: key specification without a key length
- SQL: Two select statements in one query
- Check if MySQL table exists without using “select from” syntax?
- MySQL equivalent of DECODE function in Oracle
- mysql update column with value from another table
- what is the difference between triggers, assertions and checks (in database)
- Replacing NULL with 0 in a SQL server query
- SQL Server dynamic PIVOT query?
- How to delete from multiple tables in MySQL?
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- Error converting data type varchar
- What does Include() do in LINQ?
- SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
- Get everything after and before certain character in SQL Server
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- ROW_NUMBER() in MySQ
- LEFT function in Oracle
- Foreign key references invalid table
- What are database constraints?
- Postgresql column reference “id” is ambiguous
- Inner Joining three tables
- SQLite string contains other string query
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- Sorting search results by taxonomy terms
- SQL select of users by metadata
- How to properly sanitize strings without $wpdb->prepare?
- WordPress SQL LIKE request doesn’t work for fields with special symbols
- WordPress database error: You have an error in your SQL syntax
- Better way to migrate to server?
- Inner Join user tables to select users with roles
- $wpdb->prepare with LIKE returning blank array instead of rows
- Removing posts by sql
- Why line returns are not reapply after doing esc_sql?
- WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
- WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
- Help me SELECT thumbnail from SQL and use
- Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
- Creating a “forum” – showing last post or last commented post
- Replace Unwanted Space in Post Content URL
- SQL to transform all email addresses in my DB in lowercase [closed]
- This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1