Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Srinivas
CREATE TABLE Worker(WORKER_ID INT, FIRST_NAME VARCHAR(25), LAST_NAME VARCHAR(25), SALARY INT, JOINING_DATE DATE, DEPARTMENT VARCHAR(25), PRIMARY KEY(WORKER_ID)) INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, '14-feb-20 ', 'HR'), (002, 'Niharika', 'Verma', 80000, '14-june-11 ', 'Admin'), (003, 'Vishal', 'Singhal', 300000, '14-feb-20', 'HR'), (004, 'Amitabh', 'Singh', 500000, '14-feb-20', 'Admin'), (005, 'Vivek', 'Bhati', 500000, '14-june-11 ', 'Admin'), (006, 'Vipul', 'Diwan', 200000, '14-june-11 ', 'Account'), (007, 'Satish', 'Kumar', 75000, '14-jan-20 ', 'Account'), (008, 'Geetika', 'Chauhan', 90000, '14-april-11', 'Admin')
run
|
edit
|
history
|
help
0
creation of table
Addition of two numbers
Srinivas
My_employee
Srinivas
Emp
find if Xm % n is less than z and not equal to y.
Srinivas
Srinivas
For loop