Next
4. Conditional update.
For example, the following update conditions are available:
For employees with a salary of more than 5000, the salary is reduced by 10%.
Employees with salaries between 2000 and 4600 increase by 15%
You can easily choose to execute two update statements, as shown below:
-- Condition 1UpdatePersonnelSetSalary = salesary * 0.9WhereSalary >=5000;-- Condition 2UpdatePersonnelSetSalary = salesary * 1.15WhereSalary> = 2000AndSalary
However, it is
How to Use Case in SQL (Part 2)
Next
4. Conditional update.
For example, the following update conditions are available:
For employees with a salary of more than 5000, the salary is reduced by 10%.
Employees with salaries between 2000 and 4600 increase by 15%
You can easily choose to execute two update statements, as shown below:
-- Condition 1Update personnelSet salary = salary * 0.9Where salary >=5000;-- Condition 2Update personnelSet salary = salary * 1.15Where salary> = 2000 and salary
McDATA announced that StorageTek will sell McDATA's Sphereon 4300 optical fiber switch with Flexport technology to its global customers, providing easy edge connections for enterprises of all sizes.
StorageTek, Vice President and General Manager of Information lifecycle management solutions, Mark? "McDATA's storage network products are very helpful for promoting StorageTek's information lifecycle management solutions because they can reduce costs and complexity for customers, it also helps the
possible in the SACK block to contain the packets that have been ordered out of order, until the length of TCP option is reached, the order of these blocks to indicate "which packets recently received", the more recent packets received ( The wording is not accurate, according to the TCP standard, should say is the data section! Should be in the front, this is similar to the principle of the LRU list. This helps the data sender to make precise decisions.2.3. When the receiving end responds with
information:In Avimainheader:The dwstart and dwlength fields specify the starting time of the AVI file and the length of the file. The units is defined bydwrate and Dwscale. The dwstart field is usually set to zero.The dwscale and dwrate fields is used to specify, the general time scale, the file would use. In the addition to the time scale, the each stream can has its own time scale. The time scale in samples per second are determined by dividing dwrate by Dwscale.In Avistreamheader:Dwscale is
DoubleSfgz, SL, SSKCS, YFGZ,A,YJS;//salary should be paid (basic salary), tax rate, calculator deduction, salary should be issued, judge the standard, pay the amount of tax//double QZD = 3500;//It's useless to start a levy.Console.Write ("Please enter your salary number:"); Yfgz=convert.todouble (Console.ReadLine ()); //(Salary payable-3500) * Tax rate-Calculator deduction = How much tax should be paid////1500//4500//9000//35000//55000//80000a=yfgz-35
have new creations. Do things as well, can not be isolated, a friendly working environment, often get unexpected harvest.The author also wrote that his father was laid off for 6000 yuan, the author used 4500 to buy a computer, it can be imagined that the author was under the pressure of how big. The author did not waste this 4500, he not only learned the knowledge of the class, but also learn other, such a
Suppose the individual income tax is: tax rate * (Salary-1600). Please write a program to calculate the income tax payable, where the tax rate is defined as:
When wages do not exceed 1600, the tax rate is 0;
When the wage is in the interval (1600, 2500), the tax rate is 5%;
When the wage is in the interval (2500, 3500), the tax rate is 10%;
When the wage is in the interval (3500, 4500), the tax rate is 15%;
When wages exceed
-- If the score is 100-if the score is 90, select * fromTblScoreselect (casewhentEnglish90then Liang whentEnglish100then excellent end) and math (casewhentMat -- if the score is greater than 100)
-- If the score is greater than 90 good
Select * from TblScore
Select English score =
(Case when tEnglish> 90 then 'Liang' when tEnglish> 100 then 'out' end ), mathematical score = (case when tMath> 90 then 'Liang' when tMath> 100 then 'out' end) from TblScore
-- Second exercise 1 2 3
Select * from user
, which has the following fields: Start, Length, scale, and rate, as described in the information:In Avimainheader:The dwstart and dwlength fields specify the starting time of the AVI file and the length of the file. The units is defined bydwrateand Dwscale. The dwstart field is usually set to zero.The dwscale and dwrate fields is used to specify, the general time scale, the file would use. In the addition to the time scale, the each stream can has its own time scale. The time scale in samples p
We have seen the "base class library" module multiple times in the previous. NET platform structure diagram (Figure 1-3 and figure 1-4. Note that in 1-3, the top of CLR is. net base class library. This base class library provides a unified, object-oriented, hierarchical, and scalable programming interface from basic input and output to data access. You can also see that the base class library can be called and extended by various languages, that is, whether it is C #, VB. NET or VC ++. net, you
, 2000Quadro FX Series:FX Go1400, FX 5800, FX 580, FX 570, FX 5600, FX 560, FX 5500, FX 550, FX 540, FX 4800, FX 4700 X2, FX 4600, FX 4500 X2, FX 4500, FX 4000, FX 380 LP, FX 3800, FX 380, FX 370 low profile, FX 3700, FX 370, FX 3500, FX $, FX 3450/4000 SDI, FX 340 0/4400, FX 1800, FX 1700, FX, FX 1400, CXQuadro Notebook Series:k5000m, k4000m, k3000m, k2000m, k1000m, 5010M, 5000M, 4000M, 3000M, 2000M, 1000M
If you want to use rancher, you need to install Docker, if the official website is not open, you can also visit the site link reference installationOf course, the official website installation rancher is also more detailed, if you can open, may wish to see
SysInfo[Root@gitlab ~]# Cat/etc/redhat-releaseCentOS Linux release 7.2.1511 (Core)[Root@gitlab ~]# Uname-aLinux gitlab 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x86_64 x86_64 x86_64 gnu/linux[Root@gitlab ~]# Docker-vDocker
3000Sohu 100 4500$ sort-k 1.1,1.1-u Facebook.txtBaidu 100 5000Google 110 5000Sohu 100 4500The same is also the case with the Guge of the first character G is not immune to the difficulty.$ sort-n-K 2-k 3-u Facebook.txtGuge 50 3000Sohu 100 4500Baidu 100 5000Google 110 5000Hey! With the two-tier sort priority set here, you do not delete any rows using-U. The original-U is going to weigh all the-K options, will be the same will be deleted, as long as th
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.