arithmetic operators in sql
You use the operators in any
clause (except the From clause)
With Date and Timestamp - can only use addition and subtraction
Add (+), Subtract (-), Multiply (*), Divide (/)arithmetic operators in sql
You use the operators in any
clause (except the From clause)
With Date and Timestamp - can only use addition and subtraction
Add (+), Subtract (-), Multiply (*), Divide (/)sql arithmetic operators
+ Add
– Subtract
* Multiply
/ Divide
% Modulocomparison operators sql
(Between) operator same as ">= <="
For example:
Select * From Employees Where salary Between 4000 AND 6000;
(NOT) operator excluding given
For example:
Select last_name, job_id From Employees
Where "Not" job_id = 'ABC';
(IN) operator in sql like "OR" operator
For example:
Select * From employees
Where department_id "IN" (60,90);
(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';
(Top N results)
Select * From Employees Where ROWNUM <=5;
(NVL) replaces NULL values with same type default
value provided.
For Example =
Select NVL(commission_percentage, 0)
From Employees;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
