Tags » Intersect

Intersect

A speck in the distance
you drew nearer
shy eyes met mine
from whispers to words
hazy to distinct

Reaching out, we grabbed each other… 76 more words

Oracle Assignment 6

  1. The following two tables are used to store Employee and their salary records.
CREATE TABLE EMPLOYEE (EMP_ID NUMBER GENERATED ALWAYS AS IDENTITY,
NAME VARCHAR2(50) NOT NULL,
DATE_OF_BIRTH DATE NOT NULL,
DESIGNATION VARCHAR2(50) NOT NULL,
DATE_OF_JOINING DATE,
DATE_OF_RESIGNATION DATE,
LAST_WORKING_DAY DATE,
CONSTRAINT EMPLOYEE_PK PRIMARY KEY(EMP_ID));

CREATE TABLE EMPLOYEE_SALARY(EMP_ID NUMBER NOT NULL,
MONTH NUMBER(2) NOT NULL,
YEAR NUMBER(4) NOT NULL,
GROSS_EARNINGS NUMBER(10,2) NOT NULL,
DEDUCTIONS NUMBER(10,2) DEFAULT 0 ON NULL,
NET_SALARY AS (TOTAL_EARNINGS - TOTAL_DEDUCTIONS),
CONSTRAINT EMPLOYEE_SALARY_PK PRIMARY KEY (EMP_ID),
CONSTRAINT EMPLOYEE_SALARY_FK1 FOREIGN KEY (EMP_ID) 
REFERENCES EMPLOYEE(EMP_ID)); 610 more words
Database

How Applicants can find out if a Job will provide Meaningful Work using Tools from Positive Psychology

Yesterday, I was a panelist at the morning session of Intersect 2018, a phenomenal event along the lines of “Tech Conference x Career Fair x Learning Exhibition”. 238 more words

Positive Psychology Insights

Set Operators

  • SQL set operators allows you to combine results from two or more SELECT statements.
  • There are UNION, UNION ALL, INTERSECT, EXCEPT
  • Syntax:

SELECT Col1, Col2, Col3 FROM T1

SET OPERATOR

SELECT Col1, Col2, Col3 FROM T2

… 104 more words
SQL Basics

Rule of Thirds

When a picture is divided into thirds, both horizontal or vertical. The most important parts of the composition of a photograph should be positioned upon the left or right vertical thirds or they could be positioned upon the top or bottom horizontal thirds. 44 more words

Digital Photography

Except and Intersect Operators

Whenever a performance tuning task involves changes to T-sql code, I aim to ensure that whilst the execution time of the query decreases significantly, the code still produces the same results.  538 more words

SQL Server