sql compare tables
(SELECT * FROM T1 MINUS SELECT * FROM T2) -- Rows that are in T1 but not in T2
UNION ALL
(SELECT * FROM T2 MINUS SELECT * FROM T1); -- Rows that are in T2 but not in T1sql compare tables
(SELECT * FROM T1 MINUS SELECT * FROM T2) -- Rows that are in T1 but not in T2
UNION ALL
(SELECT * FROM T2 MINUS SELECT * FROM T1); -- Rows that are in T2 but not in T1comparison in 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
