sqlsql-serverif-statementcase-statement
How can I make an case statement to set a cash cap for a particular person in sql?
So I am working on a compensation report and one of the requirements is that One particular person has a different cash cap than everyone else. My solution was instead of making a parameter I want to make a query that the output is dependent on the person. EX) if person= particular person than cash cap = 15,000 otherwise cash cap=10000. This is what I have so far but it gives me an error.
[my code]
error message
I'm not sure how to fix this syntax issue. Im still new to sql so Im not too sure.
Solution
Just declare the expression :
(case when mc = 'shaun meller' then 15000 else 10000 end) as cashcap
- SQL want to calculate time hours and mints of each emp
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Hackerrank Winners chart SQL advance level question
- How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
- How do I retrieve SQLite engine introspection information via Rust SQLx?
- How can I add machines to data already been sharded in SQL database?
- Doing a WHERE IN on multiple columns in Postgresql
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- What is the most suitable data type for a column in a table?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How to select non-integers (varchars) that possibly have leading zeros?
- PHP mysql table for comments
- String interpolation inside a formattable string in C#
- SQL - How to insert unique id in XML tag
- What represents a double in sql server?
- sql select query name -value pair
- What difference does WITH GRANT OPTION make?
- Replace null with 0 in MySQL
- What does # mean in SQL?
- Renaming foreign-key columns in MySQL
- The named 'CommandType' does not exist in the current context
- Build SQL queries in Python
- Insert multiple rows in ORACLE by referring 2 tables
- How can I work with SQL NULL values and JSON in a good way?
- Incorrect syntax near ''
- Extract epoch from column of timestamps in Postgres
- SQL - insert rows preserving overall number of duplicate values
- Columns to rows in one scan and one query