logo
down
shadow

SQL Modify returned select value without union


SQL Modify returned select value without union

Content Index :

SQL Modify returned select value without union
Tag : sql , By : Bruce
Date : January 12 2021, 08:33 AM

Does that help I'm trying to write an SQL statement that returns a list of employees by employee number, name, job_id and a modified salary depending on their job_id. If an employee is a VP the SELECT statement should return a salary with a %20 increase, but if they're a MAN it should return a salary with a %30 increase. Is it possible to return two different modified salaries without a union? Here's what I have so far. , You could use a case expression:
SELECT 'Employee ', EMPLOYEE_ID, 
       'named ', FIRST_NAME || ' ' || LAST_NAME AS "Full Name", 
       'with Job ID of ', JOB_ID,
       'will have a new salary of ',
       salary * CASE WHEN job_id LIKE '%VP' THEN 1.2
                     WHEN job_id LIKE '%MAN' THEN 1.3
                     ELSE 1
                END
FROM   EMPLOYEES

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

When using SELECT can you modify the value of a returned field based on other fields?


Tag : mysql , By : Angel Paunchev
Date : March 29 2020, 07:55 AM
I wish this help you When using MySQL SELECT can you change the value of a returned field based on other fields? , Update(misprints corrected):
SELECT city,state,
CASE 
 WHEN (city IS NULL OR city='') AND (state IS NULL or state='') THEN ''
 ELSE country
END as country_1
 FROM `table`

Modify text values in datagrid returned by SELECT command


Tag : javascript , By : Val
Date : March 29 2020, 07:55 AM
hope this fix your issue A month has been since this, but thought I'd add a final answer for anyone else with a similar problem.
I used the SQL REPLACE function, see: http://msdn.microsoft.com/en-us/library/ms186862.aspx
SELECT REPLACE(REPLACE(PartNumber, 'MBS1269', 'UFP-1290S'), 'MBS1262', 'UFP-1690S') AS PartNumber... (and so on)

modify value returned by SELECT with MySQL / PHP


Tag : php , By : Willem van Schevikho
Date : March 29 2020, 07:55 AM
help you fix your problem I want do such as this: , Use the below code:
$query = "SELECT username FROM users WHERE UPPER(username) = '".$username1."'";

Union select using value returned from previous select


Tag : mysql , By : Dean
Date : March 29 2020, 07:55 AM
wish of those help I have a database set up like this with two tables: , You would want to do something of this nature:
SELECT u.*
FROM `users` AS u
INNER JOIN `servers` AS s
    ON u.server_name = s.name
WHERE u.username = 'foo'
  INNER JOIN `servers` AS s ON u.server_id = s.server_id

How to obtain the number of tuple returned by each SELECT of an UNION query in postgreSQL?


Tag : sql , By : Vrki
Date : March 29 2020, 07:55 AM
this one helps. I have a query consiting a union of two SELECT queries. Each SELECT query returns an info. I'm interested in obtaining the number of tuple returned by each SELECT query. , You can use a window function for this:
SELECT table1.info AS info, count(*) over () as part_count
FROM table1, table2
WHERE table1.info < table2.info
UNION
SELECT table3.info AS info, count(*) over () 
FROM table3, table4
WHERE table3.info < table4.info;
info | part_count
-----+-----------
   a | 1
info | part_count
-----+-----------
   a | 2 
   b | 2
info | part_count
-----+-----------
   a | 1
   a | 2 
   b | 2
info 
----
   a 
   b
Related Posts Related QUESTIONS :
  • How to extract year or month,day from oracle function without using sub-query?
  • Reset sum when condition is met in Oracle
  • Date Between (Start & Now)
  • Reset running sum when condition is met in Oracle
  • Why is my date criteria filtering incorrectly in a MsysObjects query using DCount?
  • Stripping date/time delimiters in an SSIS csv export
  • SSIS Error on insertion - Error when new primary keys in Dimension table
  • How can I make a temp table of specific datetime data within a range?
  • AnalysisException: Syntax error in SQL After multiple join
  • SQL Query Multiple Columns Using Distinct on One Column Only and Using Order By
  • Sum inventory item groups
  • TSQL: Parsing strings with various characters
  • Using SQL Server : how to use select criteria based on sum
  • Inserting dynamic pivot Result into Temp table
  • Joining multiple fields in a dataset joined with descriptions
  • Conditional WHERE EXISTS in Oracle query
  • How to get the count of each unique value in a column between two dates?
  • SQL: Select only if multiple values are IN 1 column from CatalogTable
  • In a query (no editing of tables) how do I join data without any similarities?
  • Create nested json blobs in PostgreSQL
  • Getting extra dates while using cte
  • Way to alter one table if another was altered
  • Proper use of semicolons in functions and procedures
  • Cursor Not looping all the Records
  • Select inner join returns wrong result
  • Group By showing duplicates
  • Error in using subquery in access join query
  • How do I use a composite pk in a stored procedure?
  • Oracle Unique Indexes
  • Spooling data to CSV truncates
  • How do views reduce code duplication?
  • SQL: Gather right hand values from a join
  • SQL Agent Logon - What is going on?
  • How do I combine two rows of same part, but add quantities?
  • How to optimize this SQL query for a rectangular region?
  • Pass data from ssrs subreport to parent
  • how to enter values in rowguid column?
  • Read multiple tables from dataset in Powershell
  • In SQL how to I exclude a record if there are more than 3 characters after a dash
  • What is the difference between check and foreign key?
  • How to return a record from function, executed by INSERT/UPDATE rule (trigger)?
  • SQL order by oldest from Unix Timestamps
  • How to convert decode function in oracle to standard big query
  • Postgresql: An alternative to subqueries to make the query more efficient?
  • Use returned values from a query in the same procedure
  • Sum all numeric columns in database and log results
  • Release item in current year
  • Conditional function not working as intended postgresql
  • SQL trigger, results not Grouped by
  • getting more records than expected with simple query in postgresql
  • get first occurrence of a certain combination of columns
  • Converting string timestamp to local-time zone in Oracle
  • Redshift - Filter out rows that are blank to left or right of a character
  • Teradata - Know the load volume by times of a table
  • How do I replace duplicate data with random data of same length in SQL
  • How to group by using pivot table
  • How can I achieve a Join for merging two tables FULL OUTER JOIN and avoid duplicates?
  • Multi Keyword search on multi-column sql
  • Computing the median of salaries under each manager in BigQuery SQL
  • How can insert value by selecting from another
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com