Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
TARUN
CREATE TABLE Worker (WORKER_ID INT PRIMARY KEY ,FIRST_NAME CHAR(25),LAST_NAME CHAR(25),SALARY INT,JOINING_DATE DATETIME ,DEPARTMENT CHAR(25)); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, 14-02-2019, 'HR'), (002, 'Niharika', 'Verma', 80000, 14-06-2019, 'Admin'), (003, 'Vishal', 'Singhal', 300000, 14-02-2019, 'HR'), (004, 'Amitabh', 'Singh', 500000, 14-02-2019, 'Admin'), (005, 'Vivek', 'Bhati', 500000, 14-06-2019, 'Admin'), (006, 'Vipul', 'Diwan', 200000, 14-06-2019, 'Account'), (007, 'Satish', 'Kumar', 75000, 14-01-2019, 'Account'), (008, 'Geetika', 'Chauhan', 90000, 14-04-2019, 'Admin'); select * from worker; CREATE TABLE Bonus (WORKER_REF_ID INT,BONUS_AMOUNT INT,BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID)REFERENCES Worker(WORKER_ID)); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (001, 5000, 16-02-20), (002, 3000, 16-06-11), (003, 4000, 16-02-20), (001, 4500, 16-02-20), (002, 3500, 16-06-11); SELECT * FROM BONUS; CREATE TABLE Title (WORKER_REF_ID INT,WORKER_TITLE CHAR(25),AFFECTED_FROM DATETIME,FOREIGN KEY (WORKER_REF_ID)REFERENCES Worker(WORKER_ID)); INSERT INTO Title (WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM) VALUES (001, 'Manager', '2016-02-20 00:00:00'), (002, 'Executive', '2016-06-11 00:00:00'), (008, 'Executive', '2016-06-11 00:00:00'), (005, 'Manager', '2016-06-11 00:00:00'), (004, 'Asst. Manager', '2016-06-11 00:00:00'), (007, 'Executive', '2016-06-11 00:00:00'), (006, 'Lead', '2016-06-11 00:00:00'), (003, 'Lead', '2016-06-11 00:00:00'); SELECT * FROM TITLE;
run
|
edit
|
history
|
help
0
tt
Sql Queries
db6
StackOverflow_53799678
Solution 2
sarthak rana
20181117
20181cse0012dbmsca2
SQL - Find series of timestamps with small gaps
Data row generator (good performance, w/o recursive CTE)