Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Program1
CREATE TABLE employee ( emp_id INTEGER, first_name VARCHAR(20), last_name VARCHAR(20), salary INTEGER, department VARCHAR(20), city VARCHAR(20) ); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(1, 'John', 'Abraham', 1000000, 'Banking', 'Delhi'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(2, 'Michael', 'Clarke', 1000000, 'Insurance', 'Banglore'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(3, 'Roy', 'Thomas', 1000000, 'Banking', 'Gujarat'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(4, 'Tom', 'Jose', 1000000, 'Insurance', 'Delhi'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(5, 'Jerry', 'Pinto', 1000000, 'Insurance', 'Banglore'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(6, 'Philip', 'Mathew', 1000000, 'Services', 'Chandigarh'); INSERT INTO employee(emp_id, first_name, last_name, salary, department, city) VALUES(7, 'Amir', 'Khan', 1000000, 'Services', 'Delhi'); SELECT * FROM EMPLOYEE;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Test
find count of employees with salary more than their managers
Basic Except
SQL_Joins_RankingFunctions
Libros
Using Variables
sql 7
Empresa
robot-grading
ASDF
Please log in to post a comment.